Logins and Connection Pooling in SQL Server 2008 R2

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
MartyN
Posts: 7
Joined: Wed 25 Apr 2012 21:09

Logins and Connection Pooling in SQL Server 2008 R2

Post by MartyN » 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.

AndreyZ

Re: Logins and Connection Pooling in SQL Server 2008 R2

Post by AndreyZ » Thu 02 Aug 2012 14:56

Hello,

I cannot reproduce the problem. Please try creating a small sample to demonstrate the problem and send it to andreyz*devart*com .

Post Reply