What is the full Connection String WebConfig statement that incorporates DiscountASP.Net? For example, this is what I have: ___________________________________________________________ <add name ="sql2k804.discountasp.net" connectionString="Data Source=tcp:sql2k804.discountasp.net;Initial Catalog=SQL2008R2_753366_bafdb;User ID=SQL2008R2_753366_bafdb_user;Password=MYPASSWORD;"/> ______________________________________________________ Specifically, what comes immediately after "add name=" and before "connectionString="? I assumed "sql2k804.discountasp.net" but I may be very wrong. Thanks. Oguchi
This is one of the best ways to do it: <connectionStrings> <clear /> <remove name="LocalSqlServer" /> <add name="LocalSqlServer" connectionString="Data Source=tcp:sql.discountasp.net;Initial Catalog=SQL_numid_account;User ID=SQL_numid_user;Password=pw_here" providerName="System.Data.SqlClient" /> <add name="SQL2005_msftwise_userConnectionString" connectionString="Data Source=tcp:sql.discountasp.net;Initial Catalog=SQL_numid_account;User ID=SQL_numid_user;Password=pw_here" providerName="System.Data.SqlClient" /> </connectionStrings> 1) Clear, clears out the conn strings, including any default. 2) Remove, Goes one step further 3) Add, This is where you substantuate what you need. Including a default. 4) The Last section named "SQL2005_msftwise_userConnectionString" above is an example of what Visual Studio may name your local connection. All the best, Mark