| |
|
| |
ODBC Connection
String for SQL Server 2000 |
| |
|
Standard Security |
| |
|
|
Driver={SQL Server};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
|
| |
|
|
' VB.NET
Imports System.Data.Odbc
...
Dim oODBCConnection As OdbcConnection
Dim sConnString As String = _
"Driver={SQL Server};" & _
"Server=MySQLServerName;" & _
"Database=MyDatabaseName;" & _
"Uid=MyUsername;" & _
"Pwd=MyPassword"
oODBCConnection = New
Odbc.OdbcConnection(sConnString)
oODBCConnection.Open()
|
| |
|
Trusted connection |
| |
|
|
Driver={SQL Server};Server=myServerAddress;Database=myDataBase;Trusted_Connection=Yes;
|
| |
|
|
|
| |
OLE
DB, OleDbConnection (.NET) Connection String for SQL Server 2000 |
| |
|
Standard Security |
| |
|
|
Provider=sqloledb;Data Source=myServerAddress;Initial
Catalog=myDataBase;User Id=myUsername;Password=myPassword;
|
| |
|
|
' VB.NET
Imports System.Data.OleDb
...
Dim oOleDbConnection As OleDbConnection
Dim sConnString As String = _
"Provider=sqloledb;" & _
"Data Source=myServerName;" & _
"Initial Catalog=myDatabaseName;" & _
"User Id=myUsername;" & _
"Password=myPassword"
oOleDbConnection = New
OleDb.OleDbConnection(sConnString)
oOleDbConnection.Open()
|
| |
|
Trusted connection |
| |
|
|
Provider=sqloledb;Data Source=myServerAddress;Initial
Catalog=myDataBase;Integrated Security=SSPI;
|
| |
|
|
|
| |
|
Connecting to an SQL
Server instance |
| |
|
|
Provider=sqloledb;Data Source=myServerName\theInstanceName;Initial
Catalog=myDataBase; Integrated Security=SSPI;
|
| |
|
|
|
| |
|
Connect via an IP
address and Port |
| |
|
|
Provider=sqloledb;Data
Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial
Catalog=myDataBase;User ID=myUsername;Password=myPassword;
|
| |
|
|
|
| |
SqlConnection (.NET) Connection String for SQL Server 2000 |
| |
|
Standard Security |
| |
|
|
Data Source=myServerAddress;Initial Catalog=myDataBase;User
Id=myUsername; Password=myPassword;
|
| |
|
|
|
| |
|
Trusted connection |
| |
|
|
Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated
Security=SSPI;
|
| |
|
|
Imports System.Data.SqlClient
...
Dim oSQLConn As SqlConnection = New SqlConnection()
oSQLConn.ConnectionString = _
"Data Source=(local);" & _
"Initial Catalog=myDatabaseName;" & _
"Integrated Security=SSPI"
oSQLConn.Open()
|
| |
|
Connecting to an SQL
Server instance |
| |
|
|
Server=myServerName\theInstanceName;Database=myDataBase;Trusted_Connection=True;
|
| |
|
|
|
| |
|
Connect via an IP
address and Port |
| |
|
|
Data Source=190.190.200.100,1433;Network
Library=DBMSSOCN;Initial Catalog=myDataBase;User
ID=myUsername;Password=myPassword;
|
| |
|
|
|
| |
|
|
|
