SQL 2000 Strings
 

Check Out  http://www.dotnetUncle.com

Home

SQL 2000 Strings

SQL 2005 Strings

MS Access Strings

MySQL Strings

Oracle Strings

Notes on .NET

 

 

 

ODBC

Standard Security:

"Driver={SQL Server};Server=UrServerName;

Database=pubs;

Uid=myUsername;

Pwd=myPassword;"

 

Trusted connection:

"Driver={SQL Server};

Server=UrServerName;

Database=pubs;

Trusted_Connection=yes;"

 

Prompt for username and password:

oConn.Properties("Prompt") = adPromptAlways
oConn.Open "Driver={SQL Server};

Server=UrServerName;DataBase=pubs;"

 

OLE DB, OleDbConnection (.NET)

Standard Security:

"Provider=sqloledb;

Data Source=UrServerName;

Initial Catalog=pubs;

User Id=myUsername;

Password=myPassword;"

 

Trusted Connection:

"Provider=sqloledb;

Data Source=UrServerName;

Initial Catalog=pubs;

Integrated Security=SSPI;"

(use serverName\instanceName as Data Source to use

an specifik SQLServer instance, only SQLServer2000)

 

Prompt for username and password:

oConn.Provider = "sqloledb"
oConn.Properties("Prompt") = adPromptAlways
oConn.Open "Data Source=UrServerName;

Initial Catalog=pubs;"

 

Connect via an IP address:

"Provider=sqloledb;

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))

 

SqlConnection (.NET)

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

 

MS Data Shape
"Provider=MSDataShape;

Data Provider=SQLOLEDB;

Data Source=UrServerName;

Initial Catalog=pubs;

User ID=myUsername;

Password=myPassword;"