sql connection pool

[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

 

[Sean Hederman]

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.

 

[Sherif ElMetainy]

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

 

[Sahil Malik]

ADO.NET will provide you connection pooling by default unless you explicitly
turn it off. The only requirement is that the connection string must stay
*exactly* the same.

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik