Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Info

Support for ODBC was added in Profound.js 5.3.0.

...

An IBM account is required to access the downloads. Click on Downloads for IBM i Access Client Solutions, accept the license agreement, and use the ACS App Pkg link for the appropriate source operating system. For IBM i, use ACS PASE App Pkg. Installation instructions are included in each download package.

The IBM i version of the Application package installs via the open-source package manager "yum". See here for instructions on setting up yum on IBM i:

https://www.ibm.com/support/pages/node/706903

For Application Package installers for 32-bit Windows or languages other than English, visit the IBM ESS Website

...

The number of pre-start jobs should be configured based on the ODBC connection pool size used.

Security

If connecting to IBM i from outside the private network or VPN, it's recommended to use the option SSL=1 on the "connectionString" or DSN configuration to enable encrypted communications. This option requires that various IBM i services are configured for SSL, using a certificate that is trusted by the source system.

See here for details:

https://www.ibm.com/support/pages/host-servers-requiring-digital-certificate-assigned-use-secure-socket-layer-ssl-iseries-access-odbc-driver