如果判断是否连接到数据库？

[fly_rain]

我要连接的是oracle数据库，通过在做好的文本框输入用户，密码，服务器名后来进行连接，在程序中应该如何来判断是否已经连接到数据库，我用sqlca.sqlcode<>0来判断，老是不对，请教教我，谢谢！

[gwolfupb]

应该可以的啊，你的代码怎么写的啊，不会没有加connect；语句吧：）

[ideage]

Description

Reports the handle for your DBMS.

Controls

Transaction objects

Syntax

transactionobject.DBHandle ( )

Argument Description
transactionobject The current transaction object
Return value

UnsignedLong. Returns the handle for your DBMS. Transactionobject must exist, and the database must be connected. If transactionobject is NULL, DBHandle returns NULL. If transactionobject does not exist, an execution error occurs. If there is not enough memory to connect to your DBMS, DBHandle returns a negative number.

Usage

DBHandle returns a valid handle only if you are connected to the database. It is not able to determine if the database connection does not exist or has been lost.
PowerBuilder uses the database handle internally to communicate with the database. If your database supports an API with functions that PowerBuilder doesn't support, you can use DBHandle to provide the handle as an argument to one of these external functions.

[jdsnhan]

奇怪，sqlca.sqlcode<>0不行吗？继续关注

[banalman]

if Sqlca.dbHandle() >0 then
MessageBox("","Connect!")
else
MessageBox("","Connect error!")
end if

[one_bird]

Try SQLCA.DBHandle() .

if SQLCA.DBHandle() = 0 then
NOT CONNECT
else
CONNECT
end if

[fly_rain]

THANKS

[pbtech]

用connect using sqlca ,然后sqlca.sqlcode <>0 不就行了吗~~~