Easysoft.com Documentation Knowledge Base Products  |  Solutions  |  Support  |  Applications  |  Developer  |  Company

---

Assumptions:

• You are using Oracle Heterogenous Services (hsODBC) on AIX.
• You are using the unixODBC driver manager. (It does not matter if you built it yourself or are using the one that is included in the Easysoft ODBC driver distribution.)
• You have set your LIBPATH correctly to include the paths /usr/local/easysoft/unixODBC/lib and /usr/local/easysoft/lib.
• You are getting an error similar to the one below when attempting to use your defined hsODBC link in sqlplus:

  ERROR at line 1:
  ORA-28500: connection from ORACLE to a non-Oracle system returned this
  message:
  [Generic Connectivity Using ODBC]DRV_InitTdp: DB_ODBC_INTERFACE(6);
  Initialization function SQLAllocConnect not found
  DB_ODBC_INTERFACE(7); Cannot connect to shareable
  /usr/local/easysoft/unixODBC/lib/libodbc.a. Using dummy functions
  ORA-02063: preceding 3 lines from OCI1

On AIX, this problem occurs because hsODBC is linked against libodbc.so but the unixODBC you are using contains libodbc.so.1 in the libodbc.a archive. To check this:

1. cd /usr/local/easysoft/unixODBC/lib

   -or-

   cd /lib

   -or-

   cd unixODBC_install_dir

2. ar -tv libodbc.a

If this shows the archive contains libodbc.so.1 this is your problem and the solution is:

1. Become root or whoever you need to be to create files in the unixODBC lib subdirectory.

2. cd /usr/local/easysoft/unixODBC/lib

   -or-

   cd /lib

   -or-

   cd unixODBC_install_dir

3. ar -xv libodbc.a

   This should extract the file libodbc.so.1 to the current directory.

4. Rename libodbc.so.1:

   mv libodbc.so.1 libodbc.so

5. Point HSODBC at it directly by amending the HS_FDS_SHAREABLE_NAME in your init[name].ora file to be:

   HS_FDS_SHAREABLE_NAME = /usr/local/easysoft/unixODBC/lib/libodbc.so

Restart your Oracle listener. Your link should now work.

Applies To

• Products
  • Easysoft ODBC-Oracle Driver
  • Easysoft ODBC-InterBase Driver
  • Easysoft ODBC-JDBC Gateway
  • Easysoft ODBC-Sybase Driver
  • Easysoft ODBC-ODBC Bridge
  • Easysoft ODBC-SQL Server Driver
• Applications
  • Oracle