Using SGBD users

Posts   
 
    
Fernando
User
Posts: 7
Joined: 17-Oct-2006
# Posted on: 18-Dec-2006 20:35:44   

In my application, each user accesses the SGDB through its own user (SQL Server). So, i have to build my connection string dynamically.

I can set the connection string dynamically by DbUtils.ActualConnectionString, but the problem is that the system assumes the last setting for the entire application, for example, if user A set his connection string and then user B do the same, when user A make any transaction on the database, he will be using user B connection string...

How can I deal with that?

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 19-Dec-2006 08:35:13   

Use the Adapter model rather than the SelfServicing.

Fernando
User
Posts: 7
Joined: 17-Oct-2006
# Posted on: 19-Dec-2006 20:39:53   

there is no way to achive this using SelfServicing?

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 20-Dec-2006 07:48:27   

Unfortunatly No (as far as I know).

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39927
Joined: 17-Aug-2003
# Posted on: 20-Dec-2006 09:51:32   

Correct, Walaa. Selfservicing has a global connection string as it doesn't have a central object which performs the persistence actions, it is 'self servicing'. Adapter allows you fine-grained connection control.

Frans Bouma | Lead developer LLBLGen Pro