資料庫連接字串 – Informix

資料庫連接字串 - Informix

ODBC DSN -- INFORMIX 3.30 ODBC Driver

// 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

// 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

// 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

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