Connecting to a Database in SQL Server 2008R2 Express
-
Hi, I had long running queery last May, early June. I got all sorts of errors trying to connect. Then the VS2012Express Compiler gave up! Eddy Vluggen made great effords to help me, but, in the face of a non compiling compiler, I had to call it a day. That Compiler has now been fixed with the traditional indecent haste on behalf of Microsoft, (the Last Auto Ugrade apparently fixed it,got no notice of the fix, I hope it will last) However, the DB Connection String Problem has NOT Gone away. I now do wonder, Is this another Microsoft Issue, or am I doing something wrong! I have the following (More or Less)from Eddy Vluggen, and in line with the documentation.:-
public static String GetConnectionString() { string Result="server=b-pc\\\\Softguard;"+ "database=SgTextiles; " + "Name=sa;Password=12345;"+ "connection timeout=5;"; return Result; }The Code that uses this is:
String ConnectionString = GetConnectionString(); SqlConnection myConnection = new SqlConnection(ConnectionString);I get the Exception:"System.ArgumentException: Keyword not supported: 'name'." Irrespective of DB Configuration issues, the parser of the Connect String seems to choke on the Keyword 'name' (incidentely confirming the Non Case Sensitivity of the particular keyword parser). Kind Regards :)
Bram van Kampen
-
Hi, I had long running queery last May, early June. I got all sorts of errors trying to connect. Then the VS2012Express Compiler gave up! Eddy Vluggen made great effords to help me, but, in the face of a non compiling compiler, I had to call it a day. That Compiler has now been fixed with the traditional indecent haste on behalf of Microsoft, (the Last Auto Ugrade apparently fixed it,got no notice of the fix, I hope it will last) However, the DB Connection String Problem has NOT Gone away. I now do wonder, Is this another Microsoft Issue, or am I doing something wrong! I have the following (More or Less)from Eddy Vluggen, and in line with the documentation.:-
public static String GetConnectionString() { string Result="server=b-pc\\\\Softguard;"+ "database=SgTextiles; " + "Name=sa;Password=12345;"+ "connection timeout=5;"; return Result; }The Code that uses this is:
String ConnectionString = GetConnectionString(); SqlConnection myConnection = new SqlConnection(ConnectionString);I get the Exception:"System.ArgumentException: Keyword not supported: 'name'." Irrespective of DB Configuration issues, the parser of the Connect String seems to choke on the Keyword 'name' (incidentely confirming the Non Case Sensitivity of the particular keyword parser). Kind Regards :)
Bram van Kampen
Shouldn't
NamebeUser ID? -
Hi, I had long running queery last May, early June. I got all sorts of errors trying to connect. Then the VS2012Express Compiler gave up! Eddy Vluggen made great effords to help me, but, in the face of a non compiling compiler, I had to call it a day. That Compiler has now been fixed with the traditional indecent haste on behalf of Microsoft, (the Last Auto Ugrade apparently fixed it,got no notice of the fix, I hope it will last) However, the DB Connection String Problem has NOT Gone away. I now do wonder, Is this another Microsoft Issue, or am I doing something wrong! I have the following (More or Less)from Eddy Vluggen, and in line with the documentation.:-
public static String GetConnectionString() { string Result="server=b-pc\\\\Softguard;"+ "database=SgTextiles; " + "Name=sa;Password=12345;"+ "connection timeout=5;"; return Result; }The Code that uses this is:
String ConnectionString = GetConnectionString(); SqlConnection myConnection = new SqlConnection(ConnectionString);I get the Exception:"System.ArgumentException: Keyword not supported: 'name'." Irrespective of DB Configuration issues, the parser of the Connect String seems to choke on the Keyword 'name' (incidentely confirming the Non Case Sensitivity of the particular keyword parser). Kind Regards :)
Bram van Kampen