本文详细介绍了使用ODBC和OleDb通过DSN及无DSN方式连接IBM DB2数据库的方法，同时提供了使用.NET Data Provider for IBM进行连接的代码示例。涵盖不同驱动和配置参数，为开发者提供全面的DB2数据库连接指南。
数据库连接字符串 - 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();
|
扫一扫
569
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
