...

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. 

...

Creating a Data Source on Windows

On Windows, ODBC Data Sources are stored in files in a directory of your choosing. To find the directory currently configured as the location for Data Source files on your system, launch the ODBC Data Sources application by typing 'odbc data sources' into the Windows search box, and choosing the correct version for your Windows installation (usually 64-bit):

Image Added

The directory for Data Source files is shown on the File DSN tab. This tab also has an option to change the directory, if desired;

Image Added

To install a Data Source, create a text file with .dsn extension in the appropriate directory. The file name will be the DSN name. Copy/paste these contents into the file:

[ODBC]
Driver=IBM i Access ODBC Driver
System=myIBMi
Naming=1
CommitMode=0
UnicodeSQL=1
TimestampFormat=1

Make the following adjustments to the file:

• Change the value of the 'System' property to the target IBM i system's host name or IP address.
• If connecting to IBM i from outside the private network, it's recommended to add this line to the end of the file to enable encrypted communications:
  
  

SSL=1

Additional connection options can be added as desired.

The Data Source Name can now be referenced in the "connectionString" like this:

"databaseConnections": [
  {
    "name": "myIBMi",
    "driver": "odbc",
    "type": "db2i",
    "credentialsFile": `${__dirname}/credentials`,
    "driverOptions": {
      "connectionString": "FILEDSN=DATA_SOURCE_NAME;dbq=,DATALIB1,DATALIB2",
    }
  }
]

Specify the file name as the value of the FILEDSN option, without the .dsn extension.

To remove or change a DSN, simply edit or delete the file.