iSeries Access ODBC error messages

 

When an error occurs, the iSeries Access ODBC driver returns the SQLSTATE (an ODBC error code) and an error message. The driver obtains this information both from errors that are detected by the driver and from errors that are returned by the DBMS.

For errors that occur in the data source, the iSeries Access ODBC Driver maps the returned native error to the appropriate SQLSTATE. When both the iSeries Access ODBC driver and the Microsoft® Driver Manager detect an error, they generate the appropriate SQLSTATE. The iSeries Access ODBC driver returns an error message based on the message returned by the DBMS.

For errors that occur in the iSeries Access ODBC driver or the Microsoft Driver Manager, the iSeries Access ODBC driver returns an error message based on the text associated with the SQLSTATE.

 

Error message format

Error messages have the following format: 

[vendor][ODBC-component][data-source]
error-message

The prefixes in brackets ([]) identify the source of the error. The following table shows the values of these prefixes returned by the iSeries Access ODBC driver.

When the error occurs in the data source, the [vendor] and [ODBC-component] prefixes identify the vendor and name of the ODBC component that received the error from the data source.

Error source Value
Driver Manager 
[Microsoft]
[ODBC driver Manager]
[N/A]
iSeries Access ODBC driver 
[IBM(R)]
[iSeries Access ODBC driver]
N/A
NLS messages 
[IBM]
[iSeries Access ODBC driver]
Column #: NLS error message number NLS error message text
Communication layer 
[IBM]
[iSeries Access ODBC driver]

Communications link failure.Comm RC=xxxx - (message text) Where xxxx is the error number in decimal, not hexadecimal, format. Message text describing the nature of your error appears with the error number.

For more information about error message ids, see iSeries Access return codes or the iSeries Access for Windows online User's Guide.

DB2 UDB 
[IBM]
[iSeries Access ODBC driver]
[DB2 UDB]
Server error message

 

Viewing DB2 UDB error message text:

For errors that begin with: Use this CL command
SQL DSPMSGD RANGE(SQLxxxx) MSGF(QSQLMSG)
IWS or PWS DSPMSGD RANGE(ZZZxxxx) MSGF(QIWS/QIWSMSG) where ZZZ is IWS or PWS

Refer to Common ODBC errors for help with other ODBC error messages.

You can search and view NLS or communication error messages in the Service, Error and Trace message help topic in the iSeries Access for Windows online User's Guide.

 

Parent topic:

Troubleshoot ODBC

Related concepts
iSeries Access return codes Common ODBC errors