This is my situation.

I am using Oracle 10g, with OS authentication. In my database I have two schemas for e.g. schema1 and schema2.

For every user that uses our application there is equivalent user defined in Oracle database. Basically it uses Active Directory and oracle OS authentication.

When the user connects to application and than to database, the connection string looks something like this.

connString = "User Id=/; Data Source=servername"; OR connString="Data Source=release;Integrated Security=yes";

When the application connects to the database, oracle will authenticate the user against the domain and active directory.

Once its connected, I change the default schema using following sql

"alter session set current_schema=schema1"

once this is done, I can run my application just fine.

How do i achieve this usign LLGLGen Pro, I saw there is a option to change / overwrite the current schema, but that is not helping me. I am getting table or view does not exists.

Any help would be greatly appreciated.

So, depending on the user you'll redirect them to schema1 or schema2 ?

With Adapter, you can set the schema to use on the DataAccessAdapter object. However you have to get that information to the client where the DataAccessAdapter object lives. Is there a way to obtain that info via stored proc or custom query? If so, you can first execute that one, you then obtain the schema to target, and use that one with the DataAccessAdapter's schema name overwriting code.

Did you do it that way?