error while conncection to the database

Question

0.00/5 (No votes)

See more:

Hi
while connection to the server i found the error , it will not accept special characters. i tried using % before and after the special character then also it showing errors.

C#

string sqlConn = "Data Source=USER-PC%'"+\+"' %CompanyName';Initial Catalog=rack;User ID=trial;Password=trial112";

Please solve this error

Posted 26-Aug-12 19:54pm

smsheethal

Updated 26-Aug-12 20:08pm

Mehdi Gholam

v2

Add a Solution

Comments

Zoltán Zörgő 27-Aug-12 2:09am

I suppose the USER-PC is the machine running the SQL server, but is the CompanyName the fixed instance name of the SQL server as you see it in the service manager, or is it a variable? In the second case you mean that the USER-PC machine is running several different instances of SQL server?

3 solutions

Solution 3

C#

string sqlConn =@"Data Source=USER-PC;Initial Catalog=rack;User ID=trial;Password=trial112";

http://www.connectionstrings.com/[^]

Posted 26-Aug-12 20:12pm

Dev-0001

Updated 26-Aug-12 20:13pm

v2

Solution 2

string sqlConn = "Data Source=USER-PC\CompanyName;Initial Catalog=rack;User ID=trial;Password=trial112";

see data-source value it should be same as you find in login window while open your sql server
e.g.

'server name' = xyz\SQLEXPRESS

then
connection string should like below

string sqlConn = "Data Source=xyz\SQLEXPRESS;Initial Catalog=rack;User ID=trial;Password=trial112";

Happy Coding!
:)

Posted 26-Aug-12 20:04pm

Aarti Meswania

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)

Kuthuparakkal · Accepted Answer · 2012-08-26T19:59:00

try this:

C#

string sqlConn = "Data Source=USER-PC\\CompanyName;Initial Catalog=rack;User ID=trial;Password=trial112";

If it's local PC, use dot as :

"Data Source=.;Ini.....

If you are struggling with name try to ping User-PC\CompanyName...

The syntax of connection is:

Server\Instance, Port
Default port(SQL) - 1433

Verify you can connect.

When you initialize any string make sure that escape special charcters..
\ is a special charcater and you need to escape it as \\

Thanks,

Kuthuparakkal