OleDbConnections to Oracle 7 not closing  
Author Message
MarkChurchill





PostPosted: Tue Jul 05 09:03:57 CDT 2005 Top

ADO >> OleDbConnections to Oracle 7 not closing

Hi can anyone help me?! :confused:

I've got a web service that uses OleDb to connect to an Oracle 7 d
running on AIX. All works well but after running for a while my AI
server runs out of connections :( When I look there are LOADS o
connections from the web server.

I've checked the code thoroughly and I'm closing my OleDbConnectio
objects.

What am I doing wrong? :rolleyes

--
ste7ePosted from http://www.hide-link.com/

DotNet90  
 
 
Paul





PostPosted: Tue Jul 05 09:03:57 CDT 2005 Top

ADO >> OleDbConnections to Oracle 7 not closing

¤
¤ Hi can anyone help me?! :confused:
¤
¤ I've got a web service that uses OleDb to connect to an Oracle 7 db
¤ running on AIX. All works well but after running for a while my AIX
¤ server runs out of connections :( When I look there are LOADS of
¤ connections from the web server.
¤
¤ I've checked the code thoroughly and I'm closing my OleDbConnection
¤ objects.
¤
¤ What am I doing wrong? :rolleyes:

Which Oracle provider are you using? I seem to recall that Oracle's OLEDB provider (8.1.7) had a bug
that would leave open dead sessions. Upgrading to the latest version fixed the problem.


Paul
~~~~
Microsoft MVP (Visual Basic)