Connection strings for IBM DB2
Providers for IBM DB2
Community Forums
Find solutions and post questions regarding connection string related issues.
DB2 .NET Data Provider
Type
.NET Framework Class Library
Usage IBM.Data.DB2.DB2Connection
Manufacturer IBM
Usage IBM.Data.DB2.DB2Connection
Manufacturer IBM
Standard
Server=myAddress:myPortNumber;Database=myDataBase;UID=myUsername;PWD=myPassword;
The Server key value syntax is a server name / ip address and an optional port number (note the : in between).
Defining the connection pooling pool size
Server=myAddress:myPortNumber;Database=myDataBase;UID=myUsername;PWD=myPassword;Max Pool Size=100;Min Pool Size=10;
Disable connection pooling
Server=myAddress:myPortNumber;Database=myDataBase;UID=myUsername;PWD=myPassword; Pooling=false;
Connection pooling, time in pool
Server=myAddress:myPortNumber;Database=myDataBase;UID=myUsername;PWD=myPassword; Connection Lifetime=60;
Defines how many seconds the connection can remain idle in the pool before its removed from the pool.
Connection pooling, do not pool
Server=myAddress:myPortNumber;Database=myDataBase;UID=myUsername;PWD=myPassword; Connection Reset=false;
Specifying schema
Server=myAddress:myPortNumber;Database=myDataBase;UID=myUsername;PWD=myPassword; CurrentSchema=mySchema;
All unqualified SQL objects used with the current connection will be qualified with the provide schema name
Microsoft OLEDB provider for DB2
Type
OLE DB Provider
Usage Provider=DB2OLEDB
Manufacturer Microsoft
Usage Provider=DB2OLEDB
Manufacturer Microsoft
TCP/IP
Provider=DB2OLEDB;Network Transport Library=TCPIP;Network Address=xxx.xxx.xxx.xxx;Initial Catalog=MyCtlg;Package Collection=MyPkgCol;Default Schema=Schema;User ID=myUsername;Password=myPassword;
APPC
Provider=DB2OLEDB;APPC Local LU Alias=MyAlias;APPC Remote LU Alias=MyRemote;Initial Catalog=MyCtlg;Package Collection=MyPkgCol;Default Schema=Schema;User ID=myUsername;Password=myPassword;
IBM OLE DB Provider for DB2
Type
OLE DB Provider
Usage Provider=IBMDADB2
Manufacturer IBM
Usage Provider=IBMDADB2
Manufacturer IBM
TCP/IP
Provider=IBMDADB2;Database=myDataBase;Hostname=myServerAddress;Protocol=TCPIP; Port=50000;Uid=myUsername;Pwd=myPassword;
.NET Framework Data Provider for OLE DB
Type
.NET Framework Wrapper Class Library
Usage System.Data.OleDb.OleDbConnection
Manufacturer Microsoft
Usage System.Data.OleDb.OleDbConnection
Manufacturer Microsoft
Bridging to IBM OLE DB Provider for DB2
This is just one connection string sample for the wrapping OleDbConnection class that calls the underlying OLEDB provider. See respective OLE DB provider for more connection strings to use with this class.
Provider=IBMDADB2;Database=myDataBase;Hostname=myServerAddress;Protocol=TCPIP; Port=50000;Uid=myUsername;Pwd=myPassword;
IBM DB2 Driver for ODBC and CLI
Type
ODBC Driver
Usage Driver={IBM DB2 ODBC DRIVER}
Manufacturer IBM
Usage Driver={IBM DB2 ODBC DRIVER}
Manufacturer IBM
Standard
Driver={IBM DB2 ODBC DRIVER};Database=myDataBase;Hostname=myServerAddress;Port=1234; Protocol=TCPIP;Uid=myUsername;Pwd=myPassword;
.NET Framework Data Provider for ODBC
Type
.NET Framework Wrapper Class Library
Usage System.Data.Odbc.OdbcConnection
Manufacturer Microsoft
Usage System.Data.Odbc.OdbcConnection
Manufacturer Microsoft
Bridging to IBM DB2 Driver for ODBC and CLI
This is just one connection string sample for the wrapping OdbcConnection class that calls the underlying ODBC Driver. See respective ODBC driver for more connection strings to use with this class.
Driver={IBM DB2 ODBC DRIVER};Database=myDataBase;Hostname=myServerAddress;Port=1234; Protocol=TCPIP;Uid=myUsername;Pwd=myPassword;
Selected Articles