C#数据库连接字符串

 

一、IBM DB2  C#数据库连接字符串

1. ODBC DSN
2. ODBC without DSN
3. OleDb -- Microsoft Driver
4. OleDb -- IBM Driver
5. .NET DataProvider from IBM

 

1. // ODBC DSN    
2.  
3. using System.Data.Odbc;  
4.  
5. OdbcConnection conn = new OdbcConnection();  
6. conn.ConnectionString =   
7.               "Dsn=DsnName;" +   
8.               "Uid=UserName;" +   
9.               "Pwd=Secret;";   
10. conn.Open();  

 

1. // ODBC without DSN    
2.  
3. using System.Data.Odbc;  
4.  
5. OdbcConnection conn = new OdbcConnection();  
6. conn.ConnectionString =   
7.               "Driver={IBM DB2 ODBC DRIVER};" +   
8.               "DataBase=DataBaseName;" +   
9.               "HostName=ServerName;" +   
10.               "Protocol=TCPIP;" +   
11.               "Port=PortNumber;" +   
12.               "Uid=UserName;" +   
13.               "Pwd=Secret;";   
14. conn.Open();  

 

1. // OleDb -- Microsoft Driver    
2.  
3. using System.Data.OleDb;  
4.  
5. OleDbConnection conn = new OleDbConnection();  
6. conn.ConnectionString =   
7.            "Driver=DB2OLEDB;" +   
8.            "Network Transport Library=TCPIP;" +   
9.            "Network Address=xxx.xxx.xxx.xxx;" +   
10.            "Package Collection=CollectionName;" +   
11.            "Initial Catalog=DataBaseName;" +   
12.            "User id=UserName;" +   
13.            "Password=Secret;";   
14. conn.Open();  

 

1. // OleDb -- IBM Driver    
2.  
3. using System.Data.OleDb;  
4.  
5. OleDbConnection conn = new OleDbConnection();  
6. conn.ConnectionString =   
7.             "Driver=IBMDADB2;" +   
8.             "DataBase=DataBaseName;" +   
9.             "HostName=ServerName;" +   
10.             "Protocol=TCPIP;" +   
11.             "Port=PortNumber;" +   
12.             "Uid=UserName;" +   
13.             "Pwd=Secret;";   
14. conn.Open();  

  

1. // .NET DataProvider from IBM   
2.    
3.  
4. using IBM.Data.DB2;  
5.  
6. Db2Connection conn = new Db2Connection();  
7. conn.ConnectionString =   
8.               "DataBase=DataBaseName;" +   
9.               "Uid=UserName;" +   
10.               "Pwd=Secret;" +   
11. conn.Open();

 
 

  
  
二、Oracle C#数据库连接字符串 
 
 
 
 

  
  
ODBC DSN 
ODBC -- New Microsoft Driver 
ODBC -- Old Microsoft Driver 
ODBC -- Oracle Driver 
OleDb -- Microsoft Driver 
OleDb -- Oracle Driver -- Standard Connection 
OleDb -- Oracle Driver -- Trusted Connection 
.NET DataProvider from Microsoft -- Standard Connection 
.NET DataProvider from Microsoft -- Trusted Connection 
.NET DataProvider from Oracle -- Standard Connection 
.NET DataProvider from Oracle -- Trusted Connection
  
  
 
  
  
// ODBC DSN    
 
using System.Data.Odbc;  
 
OdbcConnection conn = new OdbcConnection();  
conn.ConnectionString =   
              "Dsn=DsnName;" +   
              "Uid=UserName;" +   
              "Pwd=Secret;";   
conn.Open();   
  
  
   
   
// ODBC -- New Microsoft Driver    
 
using System.Data.Odbc;  
 
OdbcConnection conn = new OdbcConnection();  
conn.ConnectionString =   
           "Driver={Microsoft ODBC for Oracle};" +   
           "Server=OracleServer.world;" +   
           "Uid=UserName;" +   
           "Pwd=Secret;";   
conn.Open();  
   
  
  
   
   
// ODBC -- Old Microsoft Driver    
 
using System.Data.Odbc;  
 
OdbcConnection conn = new OdbcConnection();  
conn.ConnectionString =   
    "Driver={Microsoft ODBC Driver for Oracle};" +   
    "ConnectString=OracleServer.world;" +   
    "Uid=UserName;" +   
    "Pwd=Secret;";   
conn.Open();   
  
  
   
   
// ODBC -- Oracle Driver    
 
using System.Data.Odbc;  
 
OdbcConnection conn = new OdbcConnection();  
conn.ConnectionString =   
    "Driver={Oracle ODBC Driver};" +   
    "Dbq=myDataBase;" + // define in tsnames.ora  
    "Uid=UserName;" +   
    "Pwd=Secret;";   
conn.Open();   
  
  
   
   
// OleDb -- Microsoft Driver    
 
using System.Data.OleDb;  
 
OleDbConnection conn = new OleDbConnection();  
conn.ConnectionString =   
              "Driver=MSDAORA;" +   
              "Data Source=ServerName;" +   
              "User id=UserName;" +   
              "Password=Secret;";   
conn.Open();   
  
  
   
   
// OleDb -- Oracle Driver -- Standard Connection    
 
using System.Data.OleDb;  
 
OleDbConnection conn = new OleDbConnection();  
conn.ConnectionString =   
              "Driver=OraOLEDB.Oracle;" +   
              "Data Source=ServerName;" +   
              "User id=UserName;" +   
              "Password=Secret;";   
conn.Open();  
   
  
  
   
   
// OleDb -- Oracle Driver -- Trusted Connection    
 
using System.Data.OleDb;  
 
OleDbConnection conn = new OleDbConnection();  
conn.ConnectionString =   
              "Driver=OraOLEDB.Oracle;" +   
              "Data Source=ServerName;" +   
              "OSAuthent=1;";  
conn.Open();  
 
// or   
 
using System.Data.OleDb;  
 
OleDbConnection conn = new OleDbConnection();  
conn.ConnectionString =   
              "Driver=OraOLEDB.Oracle;" +   
              "Data Source=ServerName;" +   
              "User id=/" +   
              "Password=;";   
conn.Open();   
  
  
   
   
// .NET DataProvider from Microsoft   
// -- Standard Connection   
   
 
using System.Data.OracleClient;  
 
OracleConnection conn = new OracleConnection();  
conn.ConnectionString =   
              "Data Source=ServerName;" +   
              "User id=UserName;";   
              "Password=Secret;";   
conn.Open();   
  
  
   
   
// .NET DataProvider from Microsoft   
// -- Trusted Connection   
   
 
using System.Data.OracleClient;  
 
OracleConnection conn = new OracleConnection();  
conn.ConnectionString =   
              "Data Source=Servername;" +   
              "Integrated Security=Yes;";   
conn.Open();  
   
  
  
   
   
// .NET DataProvider from Oracle   
// -- Standard Connection   
   
 
using Oracle.DataAccess.Client;  
 
OracleConnection conn = new OracleConnection();  
conn.ConnectionString =   
              "Data Source=ServerName;" +   
              "User id=UserName;";   
              "Password=Secret;";   
conn.Open();  
   
  
  
   
   
// .NET DataProvider from Oracle   
// -- Trusted Connection   
   
 
using Oracle.DataAccess.Client;  
 
OracleConnection conn = new OracleConnection();  
conn.ConnectionString =   
              "Data Source=Servername;" +   
              "Integrated Security=Yes;";   
conn.Open();