Trying to understand the ADO.NET connection string

[davidrobin]

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

Dim mySqlConnection as SqlConnection = new SqlConnection("server=(local)\VSdotNET;Trusted_Connection=yes;database=northwind")

The bit I don't understand is
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?

[alex_read]

In exactly the same way you would with standard ADO! I tend to connect using the server ip address and port number myself:

"Data Source=255.255.255.0,1400; Network Library=DBMSSOCN; Initial Catalog=SQLServerDBName; UID=SQLServerUserName; pwd=AnyOldPassword"

You can always use the .Net server explorer or a udl file to create the connection string as well: http://www.vbforums.com/showthread.p...&highlight=udl

[davidrobin]

When I use the following connectionstring

Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Database ;Data Source=Server

I get the following error (as attached)

I have never used this style connectionstring with ADODB so I do not know how to change it.
server=(local)\VSdotNET;Trusted_Connection=yes;database=northwind

[alex_read]

Try adding the user name & password bit as above to your connection string...

UID=SQLServerUserName; pwd=AnyOldPassword

[davidrobin]

I will only make a successful connection when I use the sa userid and password. I can use my userid and password to connect through SQL Analyser and Enterprise manager but it will fail when added to the connection string.

[davidrobin]

We don't really want to be passing passwords around.
Our plan is to use integrated security.

[wey97]

This works on my SQL database:

Dim mySqlConnection as SqlConnection = new SqlConnection("server=(local);trusted_connection=true;database=northwind")