' --- Connection string to connect to a named instance of sql server,
'     using sql username and password, and a custom query timeout of 60 seconds
Data Source=MYSERVER\INSTANCE;Initial Catalog=MyDatabase;Persist Security Info=True;User ID=myuser;Password=mypassword;Connect Timeout=60

' --- Connection string to connect to a named instance using integrated authentication
Data Source=MYSERVER\INSTANCE;Initial Catalog=MyDatabase;Integrated Security=True

' --- Connect to the default instance of a server, using integrated authentication
Data Source=MYSERVER;Initial Catalog=MyDatabase;Integrated Security=True

' --- Connect to an MS Access Database
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\mydirectory\mydatabase.mdb;

' --- Connect to an ODBC Source Using integrated authentication
DSN=somedsn

Visitor Comments