Web Applications and Oracle

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

Guest

Hi there!, I'm developing an application in asp.net and Oracle, but I have
the following problem, and is that the number of Sessions that connect to the
databases from my app growing and growing until the database displays an
ORA-00020, instead of use only one connections per user, I have two types of
connections in the database, one Shared and Dedicated, when I look at the
number of connections from the database, appears "n" connections (all of them
with status INACTIVE), is there any way to efficiently connect to the
database from web app's and use only one connection for each client? in the
code I have a cnnDB.Open(); and a cnnDB.Close(), each time I access to the
database, can you help me?
 
-JF- said:
Hi there!, I'm developing an application in asp.net and Oracle, but I
have the following problem, and is that the number of Sessions that
connect to the databases from my app growing and growing until the
database displays an ORA-00020, instead of use only one connections
per user, I have two types of connections in the database, one Shared
and Dedicated, when I look at the number of connections from the
database, appears "n" connections (all of them with status INACTIVE),
is there any way to efficiently connect to the database from web
app's and use only one connection for each client? in the code I have
a cnnDB.Open(); and a cnnDB.Close(), each time I access to the
database, can you help me?
Click to expand...

You could use an already established framework that reliably handles this
situation, such as the Enterprise Library.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html/entlib.asp
 
Back
Top