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

 

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

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

  • 发表评论
  • 评论内容:
  •  
Copyright © cubit
Powered by CSDN Blog