Connect to IBM DB2 Server (AnyDAC)

From RemObjects Software

Jump to: navigation, search

This is a AnyDAC Database Connectivity entry
Feel free to add your notes to this topic below.


Contents

Supported versions

The AnyDAC native driver supports IBM DB2 Enterprise, Workgroup or Express editions version 8 and higher. You can also work with other IBM database products, using AnyDAC/ODBC or DBX Bridge drivers.

Client software

AnyDAC requires the "IBM DB2 ODBC DRIVER" ODBC driver to be installed on the workstation. It may be downloaded from here.

Connection definition parameters

DriverID=DB2

Parameter

Description

Example value

Alias

Connection alias.

DB2Srv

Server

Host name, if Alias is not specified.

127.0.0.1

Port

Port value, if Alias is not specified.

5000

Database

Database name, if Alias is not specified.

ADDEMO

Protocol

Protocol name, if Alias is not specified.

TCPIP

UserName

The DB2 user name.

db2admin

Password

The DB2 user password.

master

LoginTimeout

Controls the amount of time in seconds an application waits for a connection attempt to timeout while waiting to establish a connection (0 specifies an infinite wait).

30

ODBCAdvanced

Allows to specify any other additional ODBC connection parameter value. The default value is "IGNOREWARNINGS=1".

MetaDefSchema

Default schema name. Design time code will exclude schema name from object name, if it is equal to MetaDefSchema.

db2admin


Usage cases

  • Connect to DB2 using existing database alias: 

DriverID=DB2
Alias=addemo
User_Name=db2admin
Password=mypwd
MetaDefSchema=db2admin
  • Connect to DB using full connection information: 

DriverID=DB2
Server=127.0.0.1
Database=addemo
Port=50000
Protocol=TCPIP
User_Name=db2admin
Password=mypwd
MetaDefSchema=db2admin

See Also

Product: RemObjects AnyDAC
Current version: AnyDAC 2.0

Glossary — Features — How To — Components — Tools — Samples — Articles — Architecture — Issues

Retrieved from "http://wiki.remobjects.com/wiki/Connect_to_IBM_DB2_Server_%28AnyDAC%29"
Personal tools