Error messages

Error messages can be generated from:

• ODBC driver
• Database system
• ODBC driver manager

An error reported on an ODBC driver has the following format:

[vendor] [ODBC_component] message

where ODBC_component is the component in which the error occurred. For example, an error message from the Progress DataDirect for ODBC for Oracle Wire Protocol driver would look like this:

[DataDirect] [ODBC Oracle Wire Protocol Driver] Invalid precision specified.

If you receive this type of error, check the last ODBC call made by your application for possible problems or contact your ODBC application vendor.

An error that occurs in the data source includes the data store name, in the following format:

[vendor] [ODBC_component] [data_store] message

With this type of message, ODBC_component is the component that received the error specified by the data store. For example, you may receive the following message from an Oracle database:

[DataDirect] [ODBC Oracle Wire Protocol Driver] [Oracle] ORA-0919: specified length too long for CHAR column

This type of error is generated by the database system. Check your database system documentation for more information or consult your database administrator.

On Windows, the Microsoft Driver Manager is a DLL that establishes connections with drivers, submits requests to drivers, and returns results to applications. An error that occurs in the Driver Manager has the following format:

[vendor] [ODBC XXX] message

For example, an error from the Microsoft Driver Manager might look like this:

[Microsoft] [ODBC Driver Manager] Driver does not support this function

If you receive this type of error, consult the Programmer’s Reference for the Microsoft ODBC Software Development Kit available from Microsoft.

On UNIX and Linux, the Driver Manager is provided by Progress DataDirect. For example, an error from the DataDirect Driver Manager might look like this:

[DataDirect][ODBC lib] String data code page conversion failed.

UNIX and Linux error handling follows the X/Open XPG3 messaging catalog system. Localized error messages are stored in the subdirectory:

locale/localized_territory_directory/LC_MESSAGES

where localized_territory_directory depends on your language.

For instance, German localization files are stored in locale/de/LC_MESSAGES, where de is the locale for German.

If localized error messages are not available for your locale, then they will contain message numbers instead of text. For example:

[DataDirect] [ODBC 20101 driver] 30040