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