How to solve unrecognized escape sequence in my pc but on client side cant connect

Question

0.00/5 (No votes)

See more:

In my winform my connectionstring like this...
<connectionstrings>
<add name="Money_Lending_Calculator.Properties.Settings.dbLoanCalculatorConnectionString"
connectionString="Data Source=My-PC\SQLEXPRESS;Initial Catalog=dbLn;User ID=sa;Password=123"
providerName="System.Data.SqlClient" />

and in client machine ,thier are in sql management studio,database engine name is .."My-PC\SQLEXPRESS"
BUT in my connection string give error " unrecognized escape sequence"

what should i do?

What I have tried:

i have tried this string also,
<add name="Money_Lending_Calculator.Properties.Settings.dbLoanCalculatorConnectionString"
connectionString="Data Source=My-PC\\SQLEXPRESS;Initial Catalog=dbLn;User ID=sa;Password=123"
providerName="System.Data.SqlClient" />

THen on client side when user connect database engine like this as server name like this"My-PC\\SQLEXPRESS"

then error occured ..intance failure..and not connect with that name..
please tell me solution for this..in advance thanks...

Posted 30-Dec-17 21:44pm

Member 13275563

Updated 1-Jan-18 1:05am

Add a Solution

Comments

Richard MacCutchan 31-Dec-17 4:00am

Where exactly in your code does that error occur?

Member 13275563 3-Jan-18 8:11am

in app.config file

Member 13275563 3-Jan-18 8:10am

in app.config file

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kornfeld Eliyahu Peter · Answer 1 · 2018-01-01T01:05:00

Solution 1

"\" is the so called 'escape' character, which means that the character following it will be interpreted as special character - if known... if no known you will receive the above error...

"My-PC\SQLEXPRESS"

In this string \S is considered to be an 'escaped' character, but unrecognized so you have the error...
To 'escape' the 'escape' character you have to double it...

Posted 1-Jan-18 1:05am

Kornfeld Eliyahu Peter

Comments

Member 13275563 3-Jan-18 8:30am

I HAVE USE WITH DOUBLE ESCAPE IN CONNECTIONSTRINGS,BUT IN CLIENT MACHINE ,IN THIER SQK MANAGEMENT STUDIO CANT CONNECT THAT DOUBLE CHARECTER