ODBC/OLE DB Connection Pool

From: Kevin Joseph (kejoseph_at_hotmail.com)
Date: 11/24/04 

Date: 24 Nov 2004 13:35:29 -0800

I am trying to get Connection Pooling to work in the ASP code (which
runs on IIS 5.0 server) and have tried numerous permutations and
combinations but all have failed. Listed are all the connection
strings I have tried. However I cannot seem to get connection pooling
to work ; I know this as the Connection Pool ODBC counters in
performance monitor show up as zero. Result is that intermittently I
get SQL_Server_does_not_exist_or_access_denied error messages in the
IIS log files.

cn.Open "Provider=sqloledb;Data
Source=server_name\instance_name;initial Catalog=XXXX;User
Id=YYYYYY;Password=ZZZZZ;;OLE DB Services=-1"

cn.Open "Provider=sqloledb;Data
Source=server_name\instance_name;initial Catalog=XXXX;User
Id=YYYYYY;Password=ZZZZZ;"

cn.Open = "Data Source='Data_Source';User
ID='YYYYYY';Password='ZZZZZZ';"

Any input on these would really help.

Kevin

Relevant Pages

  • Re: ODBC/OLE DB Connection Pool
    ... However I cannot seem to get connection pooling ... provider, ... > IIS log files. ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • ODBC/OLE DB Connection Pool
    ... I am trying to get Connection Pooling to work in the ASP code (which ... runs on IIS 5.0 server) and have tried numerous permutations and ... IIS log files. ...
    (microsoft.public.inetserver.asp.db)
  • Re: ODBC/OLE DB Connection Pool
    ... However I cannot seem to get connection pooling ... provider, ... > IIS log files. ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • ODBC/OLE DB Connection Pool
    ... I am trying to get Connection Pooling to work in the ASP code (which ... runs on IIS 5.0 server) and have tried numerous permutations and ... IIS log files. ...
    (microsoft.public.data.oledb)
  • Re: ODBC/OLE DB Connection Pool
    ... However I cannot seem to get connection pooling ... provider, ... > IIS log files. ... This email account is my spam trap so I ...
    (microsoft.public.data.oledb)