1. Miguel Alzate
  2. PowerServer 2020 or older (Obsolete)
  3. Thursday, 9 April 2020 19:04 PM UTC

Hi everyone.

Hope someone could help me with this issue:

In AEM, I have configured a connection (Data Source) to an IBM DB2 database via ODBC and the connection test is successful. When I assign this Data Source to a transaction in my application, I choose IBM DB2 as the Database Type (the Database Type list does not offer me the ODBC option).

At runtime, when connecting to the IBM database, the system displays a message that reads “Cannot find the db2locale64.dll library” (which is surely the database client) and the connection fails. The question is, why doesn't AEM require this DLL to connect to the IBM DB but the application does?

Accepted Answer
Armeen Mazda @Appeon Accepted Answer Pending Moderation
  1. Thursday, 9 April 2020 19:12 PM UTC
  2. PowerServer 2020 or older (Obsolete)
  3. # Permalink

Hi Miguel, You cannot use ODBC for IBM DB2.  The documentation explains you need to use the native driver: https://docs.appeon.com/appeon_online_help/ps2020/server_configuration_guide_for_net/supported_database_drivers.html

  1. Miguel Alzate
  2. Thursday, 9 April 2020 19:18 PM UTC
Thanks for the quick response, Armeen! I'll check the documentation and let you know any outcome.
  1. Helpful
  1. Miguel Alzate
  2. Sunday, 12 April 2020 16:36 PM UTC
Hello, Armeen.

Just two questions out of curiosity: If Appeon does not support connecting to databases via ODBC, (1) Why does this option appear in the "Data Source Type" list and, (2) Why the "Test Connection" using the "ODBC Driver" Data Source Type option is successful with my IBM DB in AEM?

  1. Helpful
  1. Armeen Mazda @Appeon
  2. Sunday, 12 April 2020 17:19 PM UTC
Please carefully take a look at the documentation link I provided you. ODBC is supported for ASE database only.

Appeon does not test the configuration of ODBC with IBM DB 2, and also we do not provide tech support for this configuration. So therefore I was pushing you not to use this. Since we haven't tested this I have no idea if it will test successfully or not, and whether you will run into problems.
  1. Helpful
There are no comments made yet.

There are replies in this question but you are not allowed to view the replies from this question.