Trying to understand the ADO.NET connection string

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

VB Code:

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?

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

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

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

UID=SQLServerUserName; pwd=AnyOldPassword

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.

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

This works on my SQL database:

VB Code:

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