asked on

ConfigurationSettings - what's wrong?

This works:

String connString="localhost\\DBserver; database=db; uid=sa; password=;";
.....

This doesn't:

in web.config:
<configuration>
<appSettings>
<add key="connString" value="localhost\\DBserver; database=db; uid=sa; password=;" /add>
</appSettings>

in .cs:
using System.Configuration;
......
String connString=ConfigurationSettings.AppSettings["connString"];
......

Error: "SQL server does not exist or access denied."

So the problem might be because IIS grabs another web.config file.
I find 1 web.config under wwwroot\projectName. Others are under C:\program Files\MS Visual Studio .NET\....
How do I know if the program is reading from another web.config?

Thanks.

keshavap

Hello,

you have made one small mistake in the configuration file.

<configuration>
<appSettings>
<add key="connString" value="localhost\\DBserver; database=db; uid=sa; password=;" /add>
</appSettings>

Replace the add tag with with & try.
<add key="connString" value="localhost\\DBserver; database=db; uid=sa; password=;" />

cheers!
Keshav.

samliam

ASKER

Sorry that was just a type here. I had it right in my code, i.e.e "/>" at the end. didn't work.

ptmcomp

Replace "localhost\\DBserver" with "localhost\DBserver"
In the String \\ is an escaped \

sedmans

I normallu have connection strings in the following format

Server=localhost\DBserver; database=db; User Id=sa; pwd=;

I am not sure whether or not you need the escaped \ in the config file.

samliam

ASKER

it works.
However, if the String is defined in the c# code, one '\' does not work, it has to be '\\', while in web.config, it's the other way around.

explain?

ASKER CERTIFIED SOLUTION

ptmcomp

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial