Re: ODBC/OLE DB Connection Pool
From: Bob Barrows [MVP] (reb01501_at_NOyahoo.SPAMcom)
Date: 11/24/04
- Next message: Michael Bauers: "Character being converted when calling Execute method"
- Previous message: Kevin Joseph: "ODBC/OLE DB Connection Pool"
- In reply to: Kevin Joseph: "ODBC/OLE DB Connection Pool"
- Next in thread: Stuart Carnie: "Re: ODBC/OLE DB Connection Pool"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 24 Nov 2004 16:54:24 -0500
Kevin Joseph wrote:
> 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.
I'm not 100% sure, but I do not think those counters will keep track of
connections in the OLEDB Session pool. You are using a native OLEDB
provider, not the provider for ODBC.
See here for more info. This article, which I admittedly have not read in a
while, may prove me wrong.
http://msdn.microsoft.com/library/en-us/dnmdac/html/pooling2.asp
Here are some more articles
http://support.microsoft.com/?scid=kb;en-us;Q176056
http://support.microsoft.com/default.aspx?scid=kb;en-us;191572
http://support.microsoft.com/default.aspx?scid=kb;en-us;324686
> Result is that intermittently I
> get SQL_Server_does_not_exist_or_access_denied error messages in the
> IIS log files.
Why do you think that connection pooling has anything to do with this
problem? Lack of connection pooling may result in an excess number of
connections being opened to your database, which may generate "too many
connections" errors, not network-related "not exists" and "access-denied"
errors.
Bob Barrows
-- Microsoft MVP - ASP/ASP.NET Please reply to the newsgroup. This email account is my spam trap so I don't check it very often. If you must reply off-line, then remove the "NO SPAM"
- Next message: Michael Bauers: "Character being converted when calling Execute method"
- Previous message: Kevin Joseph: "ODBC/OLE DB Connection Pool"
- In reply to: Kevin Joseph: "ODBC/OLE DB Connection Pool"
- Next in thread: Stuart Carnie: "Re: ODBC/OLE DB Connection Pool"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
