C#数据库连接字符串——Informix

1. ODBC DSN -- INFORMIX 3.30 ODBC Driver
2. ODBC without DSN -- INFORMIX 3.30 ODBC Driver
3. ODBC Informix-CLI 2.5 ODBC Driver
4. OleDb -- IBM Informix OleDb Provider

 

 
 
// ODBC DSN -- INFORMIX 3.30 ODBC Driver    
 
using System.Data.Odbc;  
 
OdbcConnection conn = new OdbcConnection();  
conn.ConnectionString =   
              "Dsn=DsnName;" +   
              "Host=HostName;" +   
              "Server=ServerName;" +   
              "Service=ServerName;" +   
              "Protocol=olsoctcp;" +   
              "Database=DataBaseName;" +   
              "Uid=UserName;" +   
              "Pwd=Secret;";   
conn.Open();  
   

 
 
// ODBC without DSN -- INFORMIX 3.30 ODBC Driver    
 
using System.Data.Odbc;  
 
OdbcConnection conn = new OdbcConnection();  
conn.ConnectionString =   
              "Dsn="";" +   
              "Driver={INFORMIX 3.30 32 BIT};" +   
              "Host=HostName;" +   
              "Server=ServerName;" +   
              "Service=ServerName;" +   
              "Protocol=olsoctcp;" +   
              "Database=DataBaseName;" +   
              "Uid=UserName;" +   
              "Pwd=Secret;";   
conn.Open();   

 
 
// ODBC Informix-CLI 2.5 ODBC Driver    
 
using System.Data.Odbc;  
 
OdbcConnection conn = new OdbcConnection();  
conn.ConnectionString =   
          "Driver={Informix-CLI 2.5 (32 Bit)};" +   
          "Server=ServerName;" +   
          "DataBase=DataBaseName;" +   
          "Uid=UserName;" +   
          "Pwd=Secret;";   
conn.Open();   

 
 
// OleDb -- IBM Informix OleDb Provider    
 
using System.Data.OleDb;  
 
OleDbConnection conn = new OleDbConnection();  
conn.ConnectionString =   
        "Driver=IFXOLEDBC;" +   
        "Data Source=DataBaseName@ServerName;" +   
        "User id=UserName;" +   
        "Password=Secret;";   
        "Persist Security Info=true;";   
conn.Open();