- ODBC DSN
- ODBC without DSN
- OleDb -- Microsoft Driver
- OleDb -- IBM Driver
- .NET DataProvider from IBM
- // ODBC DSN
- using System.Data.Odbc;
- OdbcConnection conn = new OdbcConnection();
- conn.ConnectionString =
- "Dsn=DsnName;" +
- "Uid=UserName;" +
- "Pwd=Secret;";
- conn.Open();
- // 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
- 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
- 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
- using IBM.Data.DB2;
- Db2Connection conn = new Db2Connection();
- conn.ConnectionString =
- "DataBase=DataBaseName;" +
- "Uid=UserName;" +
- "Pwd=Secret;" +
- conn.Open();