Changing schemas with Oracle

Posts   
 
    
asgeirgs
User
Posts: 8
Joined: 09-Sep-2008
# Posted on: 07-Jan-2009 00:41:34   

asgeirgs wrote:

Is this still an issue in the current version. I need to be able to dynamically switch between schemas without needing to re-generate or re-compile. I need to be able to do this from the app.config file of the EXE.

How do I do that ?

Thanks, Ásgeir Stefánsson

MTrinder wrote:

Like this - Schema Name Overwriting ...... ...... ......

Matt

Thanks Matt,

Can the same to be achived by doing the following to the app.config file ?

<add key="Main.ConnectionString" value="data source=els;user id=NewSchemaName;password=els_work;persist security info=false;"/> <add key="SchemaNameUsageSetting" value ="2"/> <add key="SchemaNameToUse" value ="NewSchemaName"/>

Can you verify that this is ok and will not have have any side effects please ?

Regards, Asgeir

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 07-Jan-2009 03:10:34   

That should work Asgeir.

David Elizondo | LLBLGen Support Team