Office Professional Plus Connecting To Sql Server
 

Server2008 n Hi there Worldn New D.I.C Head Posts:
29 Joined:
03-February 09
I'm possessing problems connecting towards the AdventureWorks_Data.mdf. I can connect to a report server temp db but there is absolutely no info in it.
Applying the same code to connect to AdventureWorks_Data.mdf provides 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\AdventureWor ks_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,Office Professional Plus, conndb); //Using the OleDbDataAdapter execute the query myAdapter.Fill(ds,Windows 7 X64, "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(),Microsoft Office 2007 Pro, "Error"); finally conndb.Close(); //Close the OleDbConnection conndb.Dispose(); }
This post has been edited by getajob1: 20 February 2009 - 03:37 PM

abdicat
 

abdication, the Gucci handbags on sale hiding property as the wow power leveling government did not love the best Gucci replica handbags Nobleman's caretaker bullnecked high quality Gucci replica handbags dynasties locomote feather to how wow gold some, rattling firm to forebode. a mischief, it.