Logins and Connection Pooling in SQL Server 2008 R2
Posted: Thu 02 Aug 2012 13:07
We set a default login for our apps to login into the database. If I have multiple databases in the same instance and pooling is turned on I only get the default users default database no matter what I make the dataname in the TUniConnection component. I'm using Delphi7 and version 4.1.6 of UniDac.
Example:
Database A - Main database and set as USER1 default database.
Database B - USER1 has all the access as he has in A.
Set DatabaseName to B.
Turn on Pooling.
When USER1 logs in he gets the data from A not B.
Turn pooling off.
Everything works as excpected.
Example:
Database A - Main database and set as USER1 default database.
Database B - USER1 has all the access as he has in A.
Set DatabaseName to B.
Turn on Pooling.
When USER1 logs in he gets the data from A not B.
Turn pooling off.
Everything works as excpected.