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

From: Taylor, Chris David <Chris.Taylor_at_ingrambarge.com>
Date: Wed, 19 Nov 2008 13:58:19 -0600
Message-ID: <17E4CDE8F84DC44A992E8C00767402E08619BC@spobmexc02.adprod.directory>

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

Received on Wed Nov 19 2008 - 13:58:19 CST

This message: [ Message body ]
Next message: Greg Norris: "Re: Dblink in Oracle10g"
Previous message: Jared Still: "Re: San & single point of failure"
Next in thread: Mary Bahrami: "RE: MSDAORA.DLL (Microsoft OLE DB For Oracle) Connectivity Question"
Maybe reply: Powell, Mark D: "RE: MSDAORA.DLL (Microsoft OLE DB For Oracle) Connectivity Question"
Reply: Mary Bahrami: "RE: MSDAORA.DLL (Microsoft OLE DB For Oracle) Connectivity Question"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message