Troubleshoot the IBM i connection

Each ODBC connection communicates with one IBM® i database program. This program is referred to as the host server program.

The name of the Database Server program used with TCP/IP is QZDASOINIT. It is normally located in subsystem QUSRWRK, however it can be set up differently by the system administrator.

Under normal conditions, the program is evoked transparently, and the user is not required to take action except to verify that the proper subsystems and communication protocols are running. See the Host server administration for details on administration of host server jobs.

The most common indication of a connection failure is an error message from the ODBC driver mentioning a communications link failure.

If ODBC is unable to connect to the IBM i host, perform the following troubleshooting tasks: