| T O P I C R E V I E W |
| chagen |
Posted - 09/04/2005 : 16:39:10 Hi,
I am having a problem getting connection pooling to work. Each query is spawning a new process even though my username and password credentials are set in XMLA.udl. How can I fix this.
Thanks in advance, Cathie |
| 1 L A T E S T R E P L I E S (Newest First) |
| admin |
Posted - 09/05/2005 : 22:41:14 Cathie,
Are you trying to connection pool SQL Server or Analysis Services connections?
XMLA.udl has the connection string to SQL Server. Try changing “Max Pool Size” and “Min Pool Size” in the file:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconconnectionpoolingforsqlservernetdataprovider.asp
|
|
|