Link to home
Start Free TrialLog in
Avatar of MonNerd
MonNerd

asked on

ODBC Connection pooling in a VB.NET application

Hi I have written an application which uses an ODBC connection to retrieve resultsets using datasets and SQL queries. I want to use connection pooling concept so I don't have to open and close connections all the time to optimize performance. How do I do this?? The options in the ODBC settings have been set to enable connection pooling and lazy close support is also enabled. Thanks
Avatar of ZachSmith
ZachSmith
Flag of United States of America image

Connection pooling is already running for you then.
Avatar of MonNerd
MonNerd

ASKER

So I don't have to declare an ODBC connection and open and close connections at all whenevr I have to access the database?
ASKER CERTIFIED SOLUTION
Avatar of ZachSmith
ZachSmith
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of MonNerd

ASKER

Thks a bunch. This helped me a lot.