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

来源：互联网发布：c语言标识符有哪些分类编辑：程序博客网时间：2024/05/18 02:29

ODBC DSN -- INFORMIX 3.30 ODBC Driver
ODBC without DSN -- INFORMIX 3.30 ODBC Driver
ODBC Informix-CLI 2.5 ODBC Driver
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();