ADO CONNECTION ERROR (VB-ORACLE)

[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.7, 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."

I also checked the Oracle listner log whenever this error occurs there was no Listner Log for any request. So, it looks like the connection request never reaches Oracle from VB.

Any advice please...

Thanks

AC

 

[TomKane]

I'm not really that familiar with Oracle, but:

Unfortunately that error code is probably not a lot of help as it looks like a general "catch all" error.

You could try to interrogate the errors collection to see if there are any additional error descriptions/codes or something - that sort of thing can be got from msdn.microsoft.com

Does Oracle have some kind on an activity monitor? I'm showing my ignorance now, but SQL Server has a query profiler and a query analyzer not to mention enterprise manager has a view current processes and other bit and pieces and Pervasive (Yes there is at least one user) has a file and user activity monitor. What I'm thinking is that if there is something like that in oracle you might be able to ascertain what's going on a the DB end...

This is probably more like troubleshooting than anything, but you never know.....