Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
C# SQLExpress connection String
Name: wolfmaster Date: December 26, 2005 at 06:17:33 Pacific OS: xp sp2 CPU/Ram: Athlon 2200+ 512MB
Comment:
Hi I'm trying to connect to SQLExpress database. I'm using c# express and it's sqlexpress that came with it. I want to use OleDbConnection but I can't fiqure out what is the right connection string. The database file is in the project folder (local). Using the follwing connection String : @"Provider=SQLNCLI.1;Integrated Security=true;Persist Security Info=False;AttachDbFilename=|DataDirectory|\Database1.mdf;Data Source=.\SQLEXPRESS";
Returns the following error: Could not connect to data source: No error message available.
Summary: OK im trying to connect my local machine to my local sql database in VB6 but the connection strings i`ve tried dont work, i have set ado 2.7 as a reference ,the sql service is running as server name "...
Summary: Hi there, please can someone help me out, i`m really having a tough time tring to connect to my remote mysql DB, this is the connection string i`m using : Conn3 = "DRIVER={MySQL ODBC 3.51 Driver};SERV...
Summary: Dear Friends, Pls Help. I want to write an sql statement which makes use of 2 tables in 2 different databases. How do I write the connection string. Pls Help Thanx Mala ...