VB6 - Oracle 8i ADO Connection Error

[AC123]

I am getting the following ADO Connection Error "SOMETIMES "
(VB general Error)for this statement.

"strConnection.Open strConnectString"

It's very strange it may connect many times successfully and then after somtime you may end up with this error.


I am using MSDAORA (Microsoft OLE DB Provider for Oracle)
MDAC 2.6, Windows 2000 Server,
Oracle8i Enterprise Edition Release 8.1.7.2.0

Error:
---------
Error Number : (-2147467259)

Error Description: "Oracle error occurred, but error message could not be retrieved from Oracle."

Any advice please...

Thanks

AC

 

[cjshinko]

Hi,
I've just signed up here and I too have been looking for an answer to this problem. My code is simply..

set mCNN = new Adodb.connection

mCNN.Open "Provider=msdaora;" & _
           "Data Source=hopetest;" & _
           "User Id=myuserid;" & _
           "Password=mypassword"

and I get the same exact error message.

Error Number : (-2147467259)

Error Description: "Oracle error occurred, but error message could not be retrieved from Oracle."

I am using mdac 2.8. Thanks to all for your help.