sql connection pool

  • Thread starter Thread starter techimadhu
  • Start date Start date
T

techimadhu

hi,
i have a component which creates new sql connectiona and passes the
connection object to the clients.
i want to implement a connection pool, instead of simply creating
infinite number of connections. does dotnet has any built in support
for this?
my database server is oracle 9i.

thanks,
madhu
 
I haven't done this with Oracle before, but the principle should be the
same. ODBC supports connection pooling. The connection strings will have to
be identical, and you have to go to the Microsoft ODBC Administrator (in
Administrative Tools). Go to the Connection Pooling tab, choose the Oracle
Driver you're using, and Enable the pooling for the driver.
 
Hello

Yes, .NET has built in support for connection pools. When you Close a
connection it goes back to the pool and is not actually closed. So make sure
you close the connection as soon as you are done with it. This is true for
Oracle Sql Server, ODBC and OleDb connections.

Best regards,
Sherif
 
Back
Top