
September 27th, 2001, 05:43 PM
|
|
Contributing User
|
|
Join Date: Dec 2002
Posts: 14,575
  
Time spent in forums: < 1 sec
Reputation Power: 22
|
|
|
ODBC Connection Pool
Originally posted by : mallenlee (mallenlee@yahoo.com)Anyone know why the connection pool counters (perfmon enabled in ODBC manager) don't keep track of anything?I've executed this code in an ASP page:For n = 0 To 500 Set rs = CreateObject("ADODB.Recordset") Set cn(n) = CreateObject("ADODB.Connection") cn(n).Open "DRIVER={SQL Server};SERVER=;DATABASE=Pubs;UID=sa;PWD=" rs.Open "select * from pubs..authors", cn(n) rs.Close Set rs = Nothing cn(n).Close Set cn(n) = NothingNextI've monitored the SQL connections and it is the same if ODBC Connection pool for the driver is on or off. I'm begining to think the whole thing is a big scam.
|