数据库连接字符串 - IBM DB2
ODBC DSN
// ODBC DSN
using System.Data.Odbc;
OdbcConnection conn = new OdbcConnection();
conn.ConnectionString =
"Dsn=DsnName;" +
"Uid=UserName;" +
"Pwd=Secret;";
conn.Open();
|
ODBC without DSN
// ODBC without DSN
using System.Data.Odbc;
OdbcConnection conn = new OdbcConnection();
conn.ConnectionString =
"Driver={IBM DB2 ODBC DRIVER};" +
"DataBase=DataBaseName;" +
"HostName=ServerName;" +
"Protocol=TCPIP;" +
"Port=PortNumber;" +
"Uid=UserName;" +
"Pwd=Secret;";
conn.Open();
|
OleDb -- Microsoft Driver
// OleDb -- Microsoft Driver
using System.Data.OleDb;
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString =
"Driver=DB2OLEDB;" +
"Network Transport Library=TCPIP;" +
"Network Address=xxx.xxx.xxx.xxx;" +
"Package Collection=CollectionName;" +
"Initial Catalog=DataBaseName;" +
"User id=UserName;" +
"Password=Secret;";
conn.Open();
|
OleDb -- IBM Driver
// OleDb -- IBM Driver
using System.Data.OleDb;
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString =
"Driver=IBMDADB2;" +
"DataBase=DataBaseName;" +
"HostName=ServerName;" +
"Protocol=TCPIP;" +
"Port=PortNumber;" +
"Uid=UserName;" +
"Pwd=Secret;";
conn.Open();
|
.NET DataProvider from IBM
// .NET DataProvider from IBM
using IBM.Data.DB2;
Db2Connection conn = new Db2Connection();
conn.ConnectionString =
"DataBase=DataBaseName;" +
"Uid=UserName;" +
"Pwd=Secret;" +
conn.Open();
|