Too many oracle connections by using Oracle DAL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

H

I am using Microsoft Application Datablock for Oracle to connect to my oracle data store

I am facing a weird problem, everytime we connect to oracle via asp .net oracle connection by DAL is not dropped thus creating endless connections to oracle

What exactly could be going wrong

Please suggest

Thanks
 
I do not know of a Datablock for Oracle, so I am assuming you mean the
Microsoft Oracle Data Provider. A couple of things to try here:

1. Make sure you explicitly close and dispose of all connections
2. Consider the fix at: http://support.microsoft.com/?id=330126
3. Move to the Oracle Provider from Oracle: http://otn.oracle.com - have to
register to download

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

**********************************************************************
Think Outside the Box!
**********************************************************************
Bahl said:
Hi

I am using Microsoft Application Datablock for Oracle to connect to my oracle data store.

I am facing a weird problem, everytime we connect to oracle via asp .net
Click to expand...
oracle connection by DAL is not dropped thus creating endless connections to
oracle.
 
Thanks for the info

There is an application data block from Microsoft similar to the one they suggest to use for SQL Server

This application block also comes along with Microsoft showcased application Nile 3.0 against Java.

It is an irony that we have to pay to microsoft to get this bug fix.

A
 
Back
Top