Loading ad...
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
Usage: IBM.Data.DB2.DB2Connection
Manufacturer: IBM
More info about this class library »
More info about this class library »
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
Usage: Provider=DB2OLEDB
Manufacturer: Microsoft
More info about this provider »
More info about this provider »
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
Usage: Provider=IBMDADB2
Manufacturer: IBM
More info about this provider »
More info about this provider »
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
Usage: System.Data.OleDb.OleDbConnection
Manufacturer: Microsoft
More info about this wrapper class library »
More info about this wrapper class library »
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}
Usage: Driver={IBM DB2 ODBC DRIVER}
Manufacturer: IBM
More info about this driver »
More info about this driver »
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
Usage: System.Data.Odbc.OdbcConnection
Manufacturer: Microsoft
More info about this wrapper class library »
More info about this wrapper class library »
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