RE: MSDAORA.DLL (Microsoft OLE DB For Oracle) Connectivity Question
- From: "Mary Bahrami" <mbahrami@xxxxxxxxxxxxxxxx>
- To: <Chris.Taylor@xxxxxxxxxxxxxxx>, "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 19 Nov 2008 13:00:54 -0800
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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@xxxxxxxxxxxxxxx
Other related posts:
