How to use password in C# web service web.config which has "&" in it

Question

I am unable to use a password in my connection string which has password with "&" in it, with it my service throws 500 internal server error.

When I remove "&" from the password, service runs but obviously i wont connect to Database.

e.g.

< add name="conn" connectionString="Data Source=DFF1234;Initial Catalog=PONJ1;User Id=PPID1;Password=POu&3mjl@sdRTYu" providerName="System.Data.SqlClient" >

You have to escape the string. I've had to do this before. Will look this up for you — jim tollan, Oct 15 '15 at 18:01

score 5 · Accepted Answer · edited Oct 15 '15 at 18:03

5

It will be xml decoded. So try &

edited Oct 15 '15 at 18:03

Marco

22,856
9
75
124

answered Oct 15 '15 at 18:01

Abdullah Nehir

1,027
13
23

Sorry, I typed it. but it doesn't work. I don't get you. – Akshay Oct 15 '15 at 18:02
I edited the answer. Try now. – Abdullah Nehir Oct 15 '15 at 18:04
1

& worked. Thanks – Akshay Oct 15 '15 at 18:05
Serv is 'well' on the serve. Grt nifty edits... – jim tollan Oct 15 '15 at 18:05

How to use password in C# web service web.config which has "&" in it

1 Answers1