IBM DB2 Driver for ODBC and CLI connection strings

Connects to

IBM DB2

  • Standard

    Driver={IBM DB2 ODBC DRIVER};Database=myDataBase;Hostname=myServerAddress;
    Port
    =1234;Protocol=TCPIP;Uid=myUsername;Pwd=myPassword;
  • Database Alias

    Driver={IBM DB2 ODBC DRIVER};DBALIAS=DatabaseAlias;Uid=myUsername;Pwd=myPassword;

    Try this dbalias alternative if the database keyword does not work.

  • Specifying schema

    Driver={IBM DB2 ODBC DRIVER};Database=myDataBase;Hostname=myServerAddress;
    Port
    =1234;Protocol=TCPIP;Uid=myUsername;Pwd=myPassword;CurrentSchema=mySchema;

    Using this you can use "select from myTable" instead of "select from mySchema.myTable"

Problems connecting?
Get answer in the IBM DB2 Q & A forum
ODBC DriverDriver={IBM DB2 ODBC DRIVER}Info and driver downloads

Providers

Connect

Articlesread all »

Didn't find your connection string?

Start over from the connection string reference index - or try a search!

In the Q&A forums you can ask your own question and let somebody help you.

The knowledge articles contains solutions and guides.