RE: MSDAORA.DLL (Microsoft OLE DB For Oracle) Connectivity Question

We had a similar problem with db links from sql2005 to ora10.2; I initially used msdaora.dll. It caused errors: WARNING: inbound connection timed out (ORA-3136)

And eventually prevented new oracle logins; this is fixed in 10.2.0.4. Switching to the OraOledb.oracle provider fixed the problem until we can patch.  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Taylor, Chris David Sent: Wednesday, November 19, 2008 11:58 AM To: ORACLE-L
Subject: MSDAORA.DLL (Microsoft OLE DB For Oracle) Connectivity Question  

We have a VB app using MSDAORA.DLL that doesn't seem to be disconnecting from the DB even though we have a connection close command in the VB program.  

Any of you seen something like this? We're eating up our "OPEN_CURSOR" count for this session as it process a lot of events and then finally errors out.  

I really think the problem is that the "OpenConnection" command from VB isn't getting sucessfully closed and reconnected.  

Thoughts?  

Chris Taylor

Sr. Oracle DBA

Ingram Barge Company

Nashville, TN 37205

Office: 615-517-3355

Cell: 615-354-4799

Email: chris.taylor_at_ingrambarge.com  

--
http://www.freelists.org/webpage/oracle-l