IBM DB2 Connection strings - Connectionstring Examples

Connection strings Examples for IBM DB2

.NET Data Provider for OLE DB

This is a .NET Class Library from Microsoft. The namespace for this library is System.Data.OleDb.OleDbConnection.

You can read more about OLD DB Connection from MSDN

Standard Security:

Provider=IBMDADB2;Database=yourDataBase;Hostname=yourServerAddress;Protocol=TCPIP; Port=50000;Uid=yourUsername;Pwd=yourPassword;

This is a wrapping class OleDbConnection to IBM DB2.

DB2 .NET Data Provider

This is a .NET Class Library from IBM. The namespace for this library is IBM.Data.DB2.DB2Connection.

Standard Security:

Server=yourAddress:yourPortNumber;Database=yourDataBase;UID=yourUsername;PWD=yourPassword;

Defining the connection pooling pool size:

Server=yourAddress:yourPortNumber;Database=yourDataBase;UID=yourUsername;PWD=yourPassword;Max Pool Size=100;Min Pool Size=10;

Disable connection pooling:

Server=yourAddress:yourPortNumber;Database=yourDataBase;UID=yourUsername;PWD=yourPassword; Pooling=false;

Connection pooling, time in pool:

Server=yourAddress:yourPortNumber;Database=yourDataBase;UID=yourUsername;PWD=yourPassword; Connection Lifetime=60;

Setting the connection time out. Once the timeout is expired the connection will be removed from the connections pool.

Connection pooling, do not pool:

Server=yourAddress:yourPortNumber;Database=yourDataBase;UID=yourUsername;PWD=yourPassword; Connection Reset=false;

Specifying schema:

Server=yourAddress:yourPortNumber;Database=yourDataBase;UID=yourUsername;PWD=yourPassword; CurrentSchema=yourSchema;

IBM DB2 Driver for ODBC and CLI

This is an ODBC driver from IBM. The usage for this provider is Driver={IBM DB2 ODBC DRIVER}.

Standard Security:

Driver={IBM DB2 ODBC DRIVER};Database=yourDataBase;Hostname=yourServerAddress;Port=1234; Protocol=TCPIP;Uid=yourUsername;Pwd=yourPassword;

More information about the IBM DB2 driver from IBM

Microsoft OLEDB provider for DB2

This is an OLE DB provider from Microsoft. The usage for this library is Provider=DB2OLEDB

For more information about Microsoft OLE DB click here

TCP/IP:

Provider=DB2OLEDB;Network Transport Library=TCPIP;Network Address=192.168.1.1;Initial Catalog=yourCtlg;Package Collection=yourPkgCol;Default Schema=Schema;User ID=yourUsername;Password=yourPassword;

APPC:

Provider=DB2OLEDB;APPC Local LU Alias=YourAlias;APPC Remote LU Alias=yourRemote;Initial Catalog=yourCtlg;Package Collection=yourPkgCol;Default Schema=Schema;User ID=yourUsername;Password=yourPassword;

IBM OLE DB Provider for DB2

This is an OLE DB Provider from IBM. The usage for this provider is Provider=IBMDADB2.

TCP/IP :

Provider=IBMDADB2;Database=yourDataBase;Hostname=yourServerAddress;Protocol=TCPIP; Port=50000;Uid=yourUsername;Pwd=yourPassword;