SQL 2000 Strings

Standard Security:

"Data Source=UrServerName;

Initial Catalog=pubs;

User Id=myUsername;

Password=myPassword;" 
   

OR

"Server=UrServerName;

Database=pubs;

User ID=myUsername;

Password=myPassword;

Trusted_Connection=False" 

(both connection strings produces the same result 

Trusted Connection:

"Data Source=UrServerName;

Initial Catalog=pubs;

Integrated Security=SSPI;" 

 OR

"Server=UrServerName;

Database=pubs;

Trusted_Connection=True;" 
   

(both connection strings produces the same result)

 (use serverName\instanceName as Data Source to use an

specific SQLServer instance, only SQLServer2000)

Connect via an IP address:

"Data Source=190.190.200.100,1433;

Network Library=DBMSSOCN;

Initial Catalog=pubs;

User ID=myUsername;

Password=myPassword;"

(DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the

Data Source is the port to use (1433 is the default))

Declare the SqlConnection:

C#:
using System.Data.SqlClient;
SqlConnection oSQLConn = new SqlConnection();
oSQLConn.ConnectionString="my connection string";
oSQLConn.Open();

VB.NET:
Imports System.Data.SqlClient
Dim oSQLConn As SqlConnection = New SqlConnection()
oSQLConn.ConnectionString="my connection string"
oSQLConn.Open()

Data Shape