Easysoft Data Access

Why do I get error "Initialization function SQLAllocConnect not found" when using Oracle® Heterogenous Services (hsODBC) on AIX?

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 -X32_64 -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 -X32_64 -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
  • Easysoft ODBC-Access Driver
  • Easysoft ODBC-DB2 Driver
  • Easysoft ODBC-Derby Driver
  • Easysoft ODBC-Salesforce Driver
• Applications
  • Oracle®

Knowledge Base Feedback

* Did this content help you?

Yes No Maybe

* Please select one option based on your first choice:

I'm very satisfied I think it will help, but I haven't tried it yet It is helpful, but I need more information It is helpful, but hard to understand Seemed relevant in search results, but didn't help me The information is incorrect The page contains one or more broken links

Suggest new content or let us know how we can improve this content:

(* Required Fields)

Oracle is a registered trademark of Oracle Corporation and/or its affiliates.

• About Easysoft

• Contact Us
• About Us
• Clients
• Upgrade Offer
• Blog
• Careers

• Products

• ODBC Drivers
• JDBC Drivers
• Bridges and Gateways
• In Development

• Services

• Consultancy
• Training
• Custom Development

• Licensing

• Product Licenses
• Prices

• Support

• Support Home
• Solution Wizard
• Getting Started Guides
• User Guides
• Knowledge Base

• Search

• Easysoft.com
• Documentation
• Knowledge Base

• Popular Resources

• Developer Area
• Client Applications

• Legal

• Privacy Statement

© 1993 - 2023 Easysoft Limited. All rights reserved. Oracle® is a registered trademark of Oracle® Corporation and/or its affiliates. Other trademarks and registered trademarks appearing on easysoft.com are the property of their respective owners.

• 
• 
• 
•