ODBC connection to a DB2 SQL DB? How to setup?

2

Using any ODBC driver in EasyMorph (or in any other application) works as follows:

  1. Configure all the settings in the Windows ODBC connection (DSN). Open Windows ODBC sources (64-bit!), find or create the necessary ODBC connection and configure it as necessary.

    image
    image796×588 69.9 KB

    Notice that system-wide and user-specific DSNs are configured separately.

    image

  2. Go to EasyMorph and create an ODBC connector. Use the DSN name from p.1 above.

Notice that there are various options how to specify database credentials. They can be provided either in the ODBC connection (DSN), or in EasyMorph.