[getajob1]

I am having trouble connecting to the AdventureWorks_Data.mdf. I can connect to a report server temp db but there is no data in it.
Using the same code to connect to AdventureWorks_Data.mdf gives an error "network related or instance specific error occurred
while connecting to SQL Server". I don't get it as the temp db connect works (see // above actual ran code). Help Please!

 public void LoadSql()
		{

		   // string connectionString = @"Provider=System.Data.SqlClient;
		   //							 Persist Security Info=False;
		   //							 Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS2\MSSQL\DATA\ReportServer$SQLEXPRESS2TempDB.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True;
		   //							 Integrated Security=SSPI;
		   //							 Trusted_Connection=TRUE;
		   //							 Application Name=SampleCSharpApplication";
		  //  string connectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS2\MSSQL\DATA\ReportServer$SQLEXPRESS2TempDB.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";   
			string connectionString =   @"Data Source=Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS2\MSSQL\DATA\AdventureWorks_Data.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";							 
																			  
			string sqlSel = @"Select * From Address";	 

			SqlConnection conndb = new SqlConnection(connectionString); //make a OleDbConnection object					  
			DataSet ds = new DataSet();								 //make a DataSet object
			
			try
			{				
				SqlDataAdapter myAdapter = new SqlDataAdapter(sqlSel, conndb); //Using the OleDbDataAdapter execute the query				
				myAdapter.Fill(ds, "Address");							   //Fill the DataSet with the Table 'Customers'
				gridColors.DataSource = ds.Tables["Address"];				
				myAdapter.Dispose();
			}
			catch (Exception e)
			{
				MessageBox.Show("Error in connecting! " + e.ToString(), "Error");
			}
			finally
			{				
			   conndb.Close();	 //Close the OleDbConnection
			   conndb.Dispose();
			}
		}

This post has been edited by getajob1: 20 February 2009 - 03:37 PM

[getajob1]

Found my answer my searching other peoples questions. I just had to tell it what server and attach a db file name. Thanks to all you answer people!!

string connectionString = @"server = ABM\SQLEXPRESS;integrated security = true;User Instance=True;AttachDbFilename=C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS2\MSSQL\DATA\AdventureWorksDW_Data.mdf";

This post has been edited by getajob1: 21 February 2009 - 08:23 AM