Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

ADO + Connection pooling

2 views
Skip to first unread message

njdude

unread,
Feb 21, 2007, 2:20:04 PM2/21/07
to
When i run this

sp_who


I see the connection showing up and in the next second it is gone.


The connectionstring i have is


Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security
Info=False;pooling=true;Min Pool Size=2;Max Pool Size=50;Connection
Lifetime=120;Initial Catalog=test;Data Source=TESTMACHINE\SQLEXPRESS;


And then in the log, the log grows almost every second 3 entiries !!
"Login succeeded for user 'TESTMACHINE\User'. Connection:
trusted...."
"Login succeeded for user 'TESTMACHINE\User'. Connection:
trusted...."
"Login succeeded for user 'TESTMACHINE\User'. Connection:
trusted...."


So the problem is that pooling does not seem to work. I dont see any
connections being held for more than 1 second

0 new messages