冰河の泥鱼的专栏

非学无以成才,非志无以成学.

原创 数据库连接字符串 - Informix收藏

新一篇: 数据库连接字符串 - Excel | 旧一篇: 数据库连接字符串 - Interbase

数据库连接字符串 - 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();

 

发表于 @ 2008年02月28日 13:39:00|评论(loading...)|编辑

新一篇: 数据库连接字符串 - Excel | 旧一篇: 数据库连接字符串 - Interbase

评论:没有评论。

发表评论  


当前用户设置只有注册用户才能发表评论。如果你没有登录,请点击登录
Csdn Blog version 3.1a
Copyright © 冰河の泥鱼