Cannot figure out how to make a connection to the SQL express server

• Frank Boonen

  SSC Enthusiast

  Points: 134

  More actions

  October 20, 2006 at 2:16 pm

  #170122

  Hi,

  I hope some one out there can help me out with my problem. I'm trying to make a connection with an SQL Express database. My current C# code:

  DataSet Ds_Transaction_Header = new DataSet();

  DataSet Ds_Transaction_Details = new DataSet();

  SqlConnection conn_1 = new SqlConnection("Data source=(local);Database=Touchpos SQL Server;Integrated Security=SSPI");

  conn_1.Open();

  SqlDataAdapter Da_Transaction_Header = new SqlDataAdapter("Select * from Transaction_Header",conn_1);

  SqlDataAdapter Da_Transaction_Details = new SqlDataAdapter("Select * from Transaction_Details",conn_1);

  I get a time-out on the open statement

  Best regards

  Frank

• Jason-

  SSCrazy

  Points: 2795

  More actions

  October 24, 2006 at 10:10 am

  #667635

  try

  SqlConnection conn_1 = new SqlConnection("Data source=ServerName;Database=Touchpos SQL Server;Integrated Security=SSPI");

  conn

  or

  SqlConnection conn_1 = new SqlConnection("Data source=127.0.0.1;Database=Touchpos SQL Server;Integrated Security=SSPI");

  conn

  -

• Chris Chilvers

  SSCrazy

  Points: 2260

  More actions

  October 24, 2006 at 5:37 pm

  #667732

  I think sql express often likes to install with an instance name of something like SqlExpress so you might need to use "(local)\SqlExpress" as the data source (or what ever the instance name is).