How can I change the connection string during run-time for both (Self Service) and (Adapter) models.

What I want to do is to build the connection string at run-time based on what the user enters at the Login screen (like what company he wants to use). Currently I have all the connection string data in a local Access databse that is consulted at login to build the list of companies and based on that decide what is the connection string to use for the choosen company...

Now I am thinking of using the AppConfig file as a sort of XML database to store the list of companies and their connection strings BUT I have to worry about encrypting the connection string itself

any ideas guys!!

OMAR

P.S: as a side note, can LLBL use an Access database the is encrypted with a password

omar wrote:

How can I change the connection string during run-time for both (Self Service) and (Adapter) models.

What I want to do is to build the connection string at run-time based on what the user enters at the Login screen (like what company he wants to use). Currently I have all the connection string data in a local Access databse that is consulted at login to build the list of companies and based on that decide what is the connection string to use for the choosen company...

The connectionstring set for selfservicing is global to the complete application. For adapter, see: Using the generated code / Adapter / DataAccessAdapter functionality. For selfservicing see: Using the generated code / Selfservicing / DbUtils functionality.

P.S: as a side note, can LLBL use an Access database the is encrypted with a password

Yes