Loading ad...
Connection strings for IBM DB2
Providers to use when connecting to IBM DB2
» DB2 .NET Data Provider (DB2Connection)
» Microsoft OLEDB provider for DB2
» IBM OLE DB Provider for DB2
» .NET Framework Data Provider for OLE DB (OleDbConnection)
» IBM DB2 Driver for ODBC and CLI
» .NET Framework Data Provider for ODBC (OdbcConnection)
» Microsoft OLEDB provider for DB2
» IBM OLE DB Provider for DB2
» .NET Framework Data Provider for OLE DB (OleDbConnection)
» IBM DB2 Driver for ODBC and CLI
» .NET Framework Data Provider for ODBC (OdbcConnection)
Finding this site useful?
-Say "Thanks" to Stephen Zlamany and the other contributing developers!
-Thank you! »
-Say "Thanks" to Stephen Zlamany and the other contributing developers!
-Thank you! »
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;