I found an example of a connection string on GoDotnet http://samples.gotdotnet.com/quickst...ldtreader.aspx . But I am having difficulty understanding the connection string. With ADODB I would usully use the following connection string.
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Database ;Data Source=Server
The connection string in the example is as follows
The bit I don't understand isVB Code:
Dim mySqlConnection as SqlConnection = new SqlConnection("server=(local)\VSdotNET;Trusted_Connection=yes;database=northwind")
server=(local)\VSdotNET
How do I change this to point at the SQL server on the network when I am developing on my local machine?




Reply With Quote