ADO adStateOpen and connection timeout
Posted on 1999-07-28
Hi, sometimes my connection (Dim cn as new ADODB.Connection) may timeout. And when the program tries to access the cn again, it will give error "The application requested an operation on an object with a reference to a closed or or invalid connections object".
So I added the following code to detect whether cn is still open or not :
If cn.State <> adStateOpen Then
cn.ConnectionString = connectionStr
However, I find that it does not work. It still give the a/m error or "not connected to ORACLE".
Is there any other way I can detect if the connection has already timeout so I can make a connection again?
My environment is NT, VB6, Oracle.