RE: MSDAORA.DLL (Microsoft OLE DB For Oracle) Connectivity Question
- From: "Taylor, Chris David" <Chris.Taylor@xxxxxxxxxxxxxxx>
- To: <mark.powell@xxxxxxx>, "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 20 Nov 2008 07:20:33 -0600
Well, I finally discovered what was happening. The VB program is not
using MSDAORA.DLL, but is using the MSDATASHAPE provider (which is
similar). The OracleOLE provider does NOT provide the functionality of
the MSDATASHAPE provider apparently (functionality the program/developer
requires). However, there is a bug in the MSDATASHAPE Provider.
When you open both a connection (conn.Open) and a recordset (rs.Open),
you typically close the connection (conn.Close) and in our case set the
recordset to nothing (rs.ActiveConnection=Nothing) to disconnect both
from the database, but allows the recordset to be used offline.
(Disconnected recordset)
However, due to the bug, the rs.ActiveConnection=Nothing doesn't
disconnect from the database and continues to use up open_cursors until
they are exhausted.
In case someone else stumbles across this, here is the link to the
Microsoft Bug:
http://support.microsoft.com/kb/288409
Article published under Q288409
Thanks!
Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-354-4799
Email: chris.taylor@xxxxxxxxxxxxxxx
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Powell, Mark D
Sent: Wednesday, November 19, 2008 3:33 PM
To: ORACLE-L
Subject: RE: MSDAORA.DLL (Microsoft OLE DB For Oracle) Connectivity
Question
When we were experiencing space leaks related to distributed queries MS
support told us that MS does not support MSDAORA and to use the OraOledb
provider. There is also no 64 bit version of MSDAORA and according to
the last document I reviewed at MS support, MS has no plans to create on
as the Oracle provider is recommended.
-- Mark D Powell --
Phone (313) 592-5148
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mary Bahrami
Sent: Wednesday, November 19, 2008 4:01 PM
To: Chris.Taylor@xxxxxxxxxxxxxxx; ORACLE-L
Subject: 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@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:
