Connection String Format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jim McGivney - 22 Oct 2005 21:20 GMT

I am trying to place a connection string in the appSettings section of my
web.config. I use C#.

I get an error message because of the "+" character.

<appSettings>

<add key="connString" value="Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=" + "C:\Inetpub\wwwroot\Bobo\GfxDB.mdb" + ";User Id=admin;Password=;"
/>
</appSettings>
Any suggestions would be appreciated. Thanks in advance for your help,

Jim

Reply to this Message

Kevin Spencer - 22 Oct 2005 23:21 GMT

Sure. You can only put string literals into a config file.

Signature

HTH,

Kevin Spencer
Microsoft MVP
.Net Developer
Ambiguity has a certain quality to it.

>I am trying to place a connection string in the appSettings section of my
>web.config. I use C#.
[quoted text clipped - 10 lines]
>
> Jim

Reply to this Message

MasterGaurav - 23 Oct 2005 02:24 GMT

Configuration file is not a code. So, no "+" etc allowed.

Incase you are bothered about the connection string, you can lookup at:
http://www.connectionstring.com

--
Cheers,
Gaurav Vaish
http://mastergaurav.org
----------------------

Reply to this Message

zeyais@gmail.com - 23 Oct 2005 11:09 GMT

Treat this is as XML file. You might also want to check on special
characters that you might want to use. Use encoded characters.

In this case Gaurav already has given a valid anser.

Reply to this Message

Jim McGivney - 23 Oct 2005 19:51 GMT

My work-around:
I use three different appSettings keys, and then retrieved and combined them
in the C# code.
Thanks for yor help.
Jim

> Treat this is as XML file. You might also want to check on special
> characters that you might want to use. Use encoded characters.
>
> In this case Gaurav already has given a valid anser.

Reply to this Message

Connection String Format

Free Magazines