Hi,

First, sorry for my english... i'm french ;-)

My problem :

I work on LLBLGEN 2.0 and i'm a neewbie

I have one Web Application. On this application, i'd like to create a login page where each user could select the db he would connect to.

For exemple, User1 is using the Production Database, User2 is using the Testing Database, User3 on another Database,...

In fact : One App/Multiple Connection String

My Questions :

• Is it possible ?
• If yes, is Adapter Template the best way to do this ?
• Is the solutions in the "DataAccessAdapter.vb" file ?
• Did you unterstand me ?

Thx for help

Yes it is possible and your perfectly understandable.

You should be using the Adapter, and here is how I would suggest you may do it:

1- Store the user selected connectionString in the Session object. 2- Whenever you use the DataAccessAdapter for database transactions, pass the connectionString retrieved from the Session to the DataAccessAdapter constructor or the ConnectionString property.

Perfect

So, I have another question now.

I'm working with Oracle. As you know, users can select the db they want connect to.

But the connection string generated by LLBLGEN PRO do not contain the name of the schema, but only the name of the serveur and the catalog.

My question is : how can I specify the name of the schema selected by the user, in the connection string that I have to use with the DataAccesAdapter() constructor ?

Indeed, my Oracle server contains databases which potentially contain different schemas which can all be selected by users.

I hope I'm understandable

Thx

Use schema name overwriting. See the DataAccessAdapter functionality in Using the generated code -> Adapter -> DataAccessAdapter functionality.