llblgen 2.6,vs 2008, vb.net,adapter mode,winforms

Trying to use sqlServerCatalogNameOverwrites but appears to be ignored.

Generated DAL using a db called SAJ but executing code against database RP

app.config

............... <configSections> <sectionGroup name="applicationSettings" type="System.Configuration.ApplicationSettingsGroup, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" > <section name="sqlServerCatalogNameOverwrites" type="System.Configuration.NameValueSectionHandler,System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /> </sectionGroup> </configSections> <applicationSettings> <sqlServerCatalogNameOverwrites> <add key="SAJ" value="RP" /> </sqlServerCatalogNameOverwrites> </applicationSettings> <appSettings> <add key="Main.ConnectionString" value="server=SERVER;UID=rapid;PWD=rapid01;database=Rapid Clean"/> </appSettings> .......................

When i run my program....it appears to be ignoring the overwrite b/c the generated query says....

SELECT [SAJ].[dbo].[InvNum].[AutoIndex], [SAJ].[dbo ...........

Dumb question: did you add this to your application's .config file or to the config file in the generated code? (you should add it to the config file in your application, NOT the one in the generated code).

to my app.config file in my vs 2008 project NOT my dal projects

would it be due to the 3.5 framework?

FIXED....XML AT ***** was moved as indicated below

app.config

............... <configSections> <sectionGroup name="applicationSettings" type="System.Configuration.ApplicationSettingsGroup, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" > </sectionGroup> <section name="sqlServerCatalogNameOverwrites" type="System.Configuration.NameValueSectionHandler,System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />***** </configSections> <sqlServerCatalogNameOverwrites> ***** <add key="SAJ" value="RP" /> </sqlServerCatalogNameOverwrites> <applicationSettings>

</applicationSettings> <appSettings> <add key="Main.ConnectionString" value="server=SERVER;UID=rapid;PWD=rapid01;database=Rapid Clean"/> </appSettings> .......................