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.
Logins and Connection Pooling in SQL Server 2008 R2
-
AndreyZ
Re: Logins and Connection Pooling in SQL Server 2008 R2
Hello,
I cannot reproduce the problem. Please try creating a small sample to demonstrate the problem and send it to andreyz*devart*com .
I cannot reproduce the problem. Please try creating a small sample to demonstrate the problem and send it to andreyz*devart*com .