C#数据库连接字符串——Microsoft SQL Server

1. ODBC DSN
2. ODBC -- Standard Connection
3. ODBC -- Trusted Connection
4. OleDb -- Standard Connection
5. OleDb -- Trusted Connection
6. OleDb -- via IP Address
7. .NET DataProvider -- Standard Connection
8. .NET DataProvider -- Trusted Connection
9. .NET DataProvider -- via IP Address

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

 
 
// 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  
 
using System.Data.Odbc;  
 
OdbcConnection conn = new OdbcConnection();  
conn.ConnectionString =   
              "Driver={SQL Server};" +   
              "Server=ServerName;" +   
              "DataBase=DataBaseName;" +   
              "Uid=xxxxxx;" +   
              "Pwd=xxxxxx;";   
conn.Open();  
 
// or  
 
OdbcConnection conn = new OdbcConnection();  
conn.ConnectionString =   
              "Driver={SQL Server};" +   
              "Server=ServerName;" +   
              "DataBase=DataBaseName;" +   
              "Trusted_Connection=Yes;";   
conn.Open(); 

 
 
// 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    
 
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    
 
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    
 
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  
 
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  
 
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();