企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 280|回复: 2

Unable to connect to Database

[复制链接]

72

主题

369

帖子

522

积分

中级会员

Rank: 3Rank: 3

积分
522
QQ
发表于 2014-3-20 17:08:51 | 显示全部楼层 |阅读模式
Hello Everyone,

I would like to know if anyone knows about a TI Prolog command that I can use to test if my ODBC Connection works before I start running the Process. The problem is that I clear out all my data in the Prolog section and then when the process continues it sometimes happen that the process was not able to connect to the ODBC datasource.

This leaves me with cubes with no data in and very frustrated clients!!

Thank you!
回复

使用道具 举报

82

主题

391

帖子

561

积分

中级会员

Rank: 3Rank: 3

积分
561
QQ
发表于 2014-3-20 18:38:20 | 显示全部楼层
I guess you could always set the odbc as the datasource in the front and add a very simple select * from a say a small table. It's a prolog test but it should test your odbc connection.
回复 支持 反对

使用道具 举报

85

主题

433

帖子

610

积分

中级会员

Rank: 3Rank: 3

积分
610
QQ
发表于 2014-3-20 21:18:44 | 显示全部楼层
par3 wrote:I would like to know if anyone knows about a TI Prolog command that I can use to test if my ODBC Connection works before I start running the Process.  The problem is that I clear out all my data in the Prolog section and then when the process continues it sometimes happen that the process was not able to connect to the ODBC datasource.

This leaves me with cubes with no data in and very frustrated clients!!

I use a pair of processes. (Though with the execute process command in version 9 I could get away with using just one plus some parameters, but that's neither here nor there.)

The first process, which runs a very simple and fast scalar query, sets a parameter in our chore control cube to "N" in its Prolog. The Data tab, which will only be executed if that value is returned, contains a CellPutS statement which sets the control cube value to "Y".

The second process, which does the actual work, checks the control cube and will only execute if the value is Y, otherwise it just quits.
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|小黑屋|企业绩效管理网 ( 京ICP备14007298号   

GMT+8, 2018-5-25 16:56 , Processed in 0.122968 second(s), 12 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表