July 10, 2006 at 1:24 pm
Hi,
How to enable connection pooling for ODBC source for SQL Server Driver? If you go to ODBC Data Source Administrator and go to Connection Pooling tab and click Enable then you enable the perf mon counters for connection pooling, not connection pooling itself. Also, how do I specify min and max number of connections in the pool?
Regards,Yelena Varsha
July 11, 2006 at 1:13 am
afaik this is set with the connection !
Connection Pooling in .NET Applications
conn.ConnectionString = "...;Min Pool Size=50";
perfmon can show you the counters.
you may want to read "Swimming in the .NET Connection Pool" Google for it.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
July 11, 2006 at 1:23 am
Use Data Sources (ODBC) Administrative Tools, Connection Pooling tab, and double click the driver in the list to turn on / off.
More info:
http://www.sql-server-performance.com/sk_connection_pooling_myths.asp
http://weblogs.asp.net/wallen/archive/2005/03/22/395496.aspx
Andy
July 11, 2006 at 9:36 am
Thanks Alzdba and David!
We can not do ASP.NET because it is the existing ASP application. I do know that we can use ASP and ASP.NET pages in one app but the app developer would like just modify the ASP pages.
The advice of double-clicking the driver is super! This is what I was looking for. I was on this screen many times but Enable radiobutton enables only Performance Counters, not pooling. I read all these articles but nowhere it says of opening the properties by double-clicking on the driver name.
I also found the article late yesterday that uses DSN-less connection for pooling and explains what ADO statements support pooling. There is the code example too but with one typo, you have to change >% to <%
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q191572
INFO: Connection Pool Management by ADO Objects Called From ASP
Thanks again,
Regards,Yelena Varsha
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy