数据库连接字符串 - Microsoft SQL Server

数据库连接字符串 - Microsoft SQL Server

ODBC DSN

// ODBC DSN   using System.Data.Odbc;   OdbcConnection conn = new OdbcConnection(); conn.ConnectionString =               "Dsn=DsnName;" +               "Uid=UserName;" +               "Pwd=Secret;"; conn.Open();

 

ODBC -- Standard Connection

// ODBC -- Standard Connection   using System.Data.Odbc;   OdbcConnection conn = new OdbcConnection(); conn.ConnectionString =               "Driver={SQL Server};" +               "Server=ServerName;" +               "DataBase=DataBaseName;" +               "Uid=UserName;" +               "Pwd=Secret;"; conn.Open();

 

ODBC -- Trusted Connection

// ODBC -- Trusted Connection   using System.Data.Odbc;   OdbcConnection conn = new OdbcConnection(); conn.ConnectionString =               "Driver={SQL Server};" +               "Server=ServerName;" +               "DataBase=DataBaseName;" +               "Uid=;" +               "Pwd=;"; conn.Open();   // or   OdbcConnection conn = new OdbcConnection(); conn.ConnectionString =               "Driver={SQL Server};" +               "Server=ServerName;" +               "DataBase=DataBaseName;" +               "Trusted_Connection=Yes;"; conn.Open();

 

OleDb -- Standard Connection

// OleDb -- Standard Connection   using System.Data.OleDb;   OleDbConnection conn = new OleDbConnection(); conn.ConnectionString =               "Driver=SQLOLEDB;" +               "Data Source=ServerName;" +               "Initial Catalog=DataBaseName;" +               "User id=UserName;" +               "Password=Secret;"; conn.Open();

 

OleDb -- Trusted Connection

// OleDb -- Trusted Connection   using System.Data.OleDb;   OleDbConnection conn = new OleDbConnection(); conn.ConnectionString =               "Driver=SQLOLEDB;" +               "Data Source=ServerName;" +               "Initial Catalog=DataBaseName;" +               "Integrated Security=SSPI;"; conn.Open();

 

OleDb -- via IP Address

// OleDb -- via IP Address   using System.Data.OleDb;   OleDbConnection conn = new OleDbConnection(); conn.ConnectionString =               "Driver=SQLOLEDB;" +               "Network Library=DBMSSOCN;" +               "Data Source=xxx.xxx.xxx.xxx,1433;" +               "Initial Catalog=DataBaseName;" +               "User id=UserName;" +               "Password=Secret;"; conn.Open();

 

.NET DataProvider -- Standard Connection

// .NET DataProvider -- Standard Connection   using System.Data.SqlClient;   SqlConnection conn = new SqlDbConnection(); conn.ConnectionString =               "Data Source=ServerName;" +               "Initial Catalog=DataBaseName;" +               "User id=UserName;" +               "Password=Secret;"; conn.Open();

 

.NET DataProvider -- Trusted Connection

// .NET DataProvider -- Trusted Connection   using System.Data.SqlClient;   SqlConnection conn = new SqlConnection(); conn.ConnectionString =               "Data Source=ServerName;" +               "Initial Catalog=DataBaseName;" +               "Integrated Security=SSPI;"; conn.Open();

 

.NET DataProvider -- via IP Address

// .NET DataProvider -- via IP Address   using System.Data.SqlClient;   SqlConnection conn = new SqlConnection(); conn.ConnectionString =               "Network Library=DBMSSOCN;" +               "Data Source=xxx.xxx.xxx.xxx,1433;" +               "Initial Catalog=DataBaseName;" +               "User id=UserName;" +               "Password=Secret;"; conn.Open();