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 forODBC for Oracle Wire Protocol driver would look like this:
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 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, Linux, and macOS 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
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 macOS, the iODBC Driver Manager 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] [Driver Manager] message
For example, an error from the Microsoft Driver Manager might look like this:
[iODBC] [Driver Manager] Specified driver could not be loaded
If you receive this type of error, consult the iODBC documentation at http://www.iodbc.org/.
ODBC driver
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:
On macOS, the iODBC Driver Manager 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: