Re: ODBC/OLE DB Connection Pool

From: Erland Sommarskog (esquel_at_sommarskog.se)
Date: 11/27/04 

Date: Sat, 27 Nov 2004 22:56:03 +0000 (UTC)

Mark (Mark@discussions.microsoft.com) writes:
> Just to throw something else in the works - if Application Roles are
> used in SQL Server then connection pooling will not work. I forget
> whether it causes errors to be raised or if it just doesn't work
> properly, or which version of ADO or OLEDB driver it's specific to.
>
> Are Application Roles being used in this case?
 
It's rather the other way round. Application roles does not work if you have
pooling on, because you cannot set the application role on a connection
more than once. So you need to turn off pooling by adding OLE DB Services=-2
to the connection string. 

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

Relevant Pages