Troubleshooting
Problem
The DataDirect example program output shows the error message: bash-3.00$ ./example ./example DataDirect Technologies, Inc. ODBC Example Application. Enter the data source name : NZSQL Enter the user name : testuser Enter the password : password SQLSTATE = IM003 NATIVE ERROR = 0 MSG = [DataDirect][ODBC lib] Specified driver could not be loaded SQLConnect: Retrying Connect. SQLSTATE = IM003 NATIVE ERROR = 0 MSG = [DataDirect][ODBC lib] Specified driver could not be loaded The above error occurred when a user attempted to test an ODBC connection using the DataDirect program named example.
Cause
The error occurs because the DataDirect driver manager requires an ODBC library with a file name extension of .so.
On HP-UX systems, the file name extension for the ODBC driver is .sl. On AIX systems, the file name extension is .a.
Resolving The Problem
To prevent this error, do the following:
1. Edit the driver name specified in the odbc.ini and odbcinst.ini files and replace either libnzodbc.a or libnzodbc.sl with libnzodbc.so.
2. Then create a symbolic link for libnzodbc.so that points to the real file.
cd /usr/local/nz/lib
ln -s libnzodbc.a libnzodbc.so
ls -l libnzodbc*
Historical Number
NZ690570
Was this topic helpful?
Document Information
Modified date:
17 October 2019
UID
swg21570765