DB2 Connections?

1

Can I make a DB2 connector?

ODBC drivers required: DB2

Port: 6000

(uid and password known, as is the hostname).

2

You can create an ODBC connector in EasyMorph and select the SQL dialect for DB2 in it. Note that only DB2 LUW is supported. DB2 for AS/400 is not supported.

3

I am using 3.9.9.29

When I go to create a new connection in the connection manager

SQL -> ODBC

I get the following Configuration screen: (the dialect is already chosen for me, I don't seem to be able to choose DB2).

(the only options in the DSN dropdown that appear are (Excl, MS Access, and Visio).

Annotation
Annotation1143×803 45.1 KB

4

Pick a data source and then it will offer to select an SQL dialect. EasyMorph tries to automatically detect the most appropriate SQL dialect, but an ODBC data source should be selected first.

5

As I stated, the ONLY choices I have for the datasource are:

  1. Excel Files
  2. MS Access Database
  3. Visio DataBase Samples

None match a DB2 Database.

I have done all the setup from my windows10 client to the Windows 10 machine hosting the DB2 database:

1.	Download drivers from here.

https://www.ibm.com/support/pages/download-initial-version-115-clients-and-drivers
6

Do you see the configured DB2 connector in the Windows system ODBC dialog (similar to below) either in System DSNs or in User DSNs?

image
image594×421 19.5 KB

If it's not there, it means that the driver/connector not installed/configured properly on the system level.

7

Thanks for the tip. That got me farther. But as cyou can see there is still something wrong. But this might be an issue external to EasyMorph.

image
image656×827 40.4 KB

8

EasyMorph is a 64-bit application. It can only work with 64-bit drivers. Your driver is 32-bit. Install a 64-bit DB2 driver, then it should work.