Regaring Establishing Connection with sqlserver.

[dayakar_dn]

Hi All, I am getting a strange error while establishing connection with sqlserver. i written the following code to establish the connection string sqlStatement = "select * from Student_Table"; String dataBaseConnection = "Data Source=DREDDY9/SQLEXPRESS;Initial Catalog=SampleDataBase;Integrated Security=SSPI"; SqlConnection myConnection = new SqlConnection(dataBaseConnection); SqlCommand myCommand = new SqlCommand(sqlStatement, myConnection); SqlDataReader dr; myConnection.Open(); dr = myCommand.ExecuteReader(); if(dr!=null) { Response.Write("Successfully Executed"); } myConnection.Close(); To resolve this i tried with enabling local and remote connections and i enabled sql server browser. but no use any body is having any solution. please shere it.

[dan sh]

What is the error?

It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD

[i i i]

what kind of error you are facing are you enable to connect if so then try

Data Source=./SQLEXPRESS instead off Data Source=DREDDY9/SQLEXPRESS

also check your protocols you are connecting with tcp/ip or named pipes and the user from which you are going to connect should have rights to connect to the db.

Best Of Regards, SOFTDEV If you have knowledge, let others light their candles at it

[i i i]

look out for slash it should be \ not / Data Source=DREDDY9/SQLEXPRESS; Data Source=DREDDY9**\**SQLEXPRESS; :doh:

Best Of Regards, SOFTDEV If you have knowledge, let others light their candles at it