SqlClient will not connect to 2005 SqlServer
-
OleDb connects fine? VS2005; C#; SQL 2005 Developer (remote server) SqlClient connection string: "data source=MyRemoteServer;user id=MyUserID;password=MyPassword;initial catalog=DbName;workstation id=PC1" OleDb connection string: "provider=SQLxxxx;data source=MyRemoteServer;user id=MyUserID;password=MyPassword;initial catalog=DbName;workstation id=PC1" (xxxx = I forget the exact provider string) OleDb connects fine, SqlClient times out looking for the server? Am I missing something obvious? Should I really worry about this - I thought SqlClient was faster and better? Thanks Ian
-
OleDb connects fine? VS2005; C#; SQL 2005 Developer (remote server) SqlClient connection string: "data source=MyRemoteServer;user id=MyUserID;password=MyPassword;initial catalog=DbName;workstation id=PC1" OleDb connection string: "provider=SQLxxxx;data source=MyRemoteServer;user id=MyUserID;password=MyPassword;initial catalog=DbName;workstation id=PC1" (xxxx = I forget the exact provider string) OleDb connects fine, SqlClient times out looking for the server? Am I missing something obvious? Should I really worry about this - I thought SqlClient was faster and better? Thanks Ian
Did you get this to work?
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus