Error in connection string

Question

hiii friends. i am using following code and it shows error near bold SqlConnection cn = new SqlConnectio n('.\SQ L;User Id=sa;Password=pass@123;Initial Catalog=test'); help me..its urgent

Pankaj Pandey · Answer

try it.. SqlConnection cn = new SqlConnectio n(" Data Source= your server name ;User Id=sa;Password=pass@123;Initial Catalog=test")

Amit Choudhary · Answer

Try below: SqlConnection cn = new SqlConnection(".\SQL;User Id=sa;Password=pass@123;Initial Catalog=test");

RIM Singh · Answer

thanks sir Error was "@" and also in connection string..i am using now.. SqlConnection cn = new SqlConnection(@"Data Source=.\sqlexpress;User Id=sa;Password=pass@123;Initial Catalog=test"); it works thnx

Pankaj Pandey · Answer

try it.. SqlConnection cn = new SqlConnectio n(@".\SQ L;User Id=sa;Password=pass@123;Initial Catalog=test"); i hope it will work, because connection string is ok, if not then check your sql server setting. open sql server, put .\SQ L in server name, select window authentication and press ok, if it connect then it means connection string is ok...other wise you entered wrong server name. mark as answered if helpful

Riyaz Akhtar · Answer

try this SqlConnection cn = new SqlConnection("Data Source=.\sqlexpress;User Id=sa;Password=pass@123;Initial Catalog=test");

RIM Singh · Answer

i tried it.. it is not working..

Error in connection string

Answers (6)