Problem with TOracleSession

[mmartinic]

Hello,

I have couple of Oracle servers and I want
to connect to first available server from the list. The user must be connected at any time, and it's not relevant with which Oracle server this connection is made, because each server have the same database structure.

I thought - no big deal, but now I have problem to detect is Oracle server available or not. In any case (i.e. for wrong TNS name and/or UserName and/or Password) TOracleSession reporting that connection exists.

I've tried to handle this with try..except statement, like in DOA Help, but I don't have Exception and I cannot know am I have connection to Oracle or not.

For this, after Session.LogOn I'm checking connection with OracleQuery1.Execute. This Query contain only "COMMIT". I don't have Exception again. So, for application everything seem OK, and when user want to retrieve data from database, there is a error message.

Is there any way to handle/recognize invalid parameters for connection to Oracle?

Combination is : Delphi 6 Enterprise, DOA 3.4.5 and Oracle 8.1.7.

Mickey

 

[foldenm]

Try checking the Session.Connected property.
It will tell you whether or not the session
is actively connected to a database...

Originally posted by mmartinic:
Hello,

I have couple of Oracle servers and I want
to connect to first available server from the list. The user must be connected at any time, and it's not relevant with which Oracle server this connection is made, because each server have the same database structure.

I thought - no big deal, but now I have problem to detect is Oracle server available or not. In any case (i.e. for wrong TNS name and/or UserName and/or Password) TOracleSession reporting that connection exists.

I've tried to handle this with try..except statement, like in DOA Help, but I don't have Exception and I cannot know am I have connection to Oracle or not.

For this, after Session.LogOn I'm checking connection with OracleQuery1.Execute. This Query contain only "COMMIT". I don't have Exception again. So, for application everything seem OK, and when user want to retrieve data from database, there is a error message.

Is there any way to handle/recognize invalid parameters for connection to Oracle?

Combination is : Delphi 6 Enterprise, DOA 3.4.5 and Oracle 8.1.7.

Mickey