Download ODBC Drivers for Oracle, SQL Server, Salesforce, MongoDB, Access, Derby, InterBase & DB2.

Easysoft Data Access

Why do I get error "Generic Connectivity Using ODBC][C077] Could not find symbol 'SQLAllocConnect' in dynamic library"?

Article:
01010
Last Reviewed:
2nd January 2024
Revision:
1

The full text of the error reported to us was:

Error : ORA-28500: connection from ORACLE to a non-Oracle system returned this
message: Generic Connectivity Using ODBC][C077] Could not find symbol
'SQLAllocConnect' in dynamic library

This error usually occurs for one of the following reasons:

  1. Library search path is not set for your Easysoft ODBC driver.

    On the machine where the Easysoft ODBC driver is installed, you need to ensure the library search path includes the Easysoft driver directories. Do this before you start your Oracle listener:

    The environment variable you use to set the library search path varies:

    Platform Environment variable
    AIX LIBPATH
    HP-UX SHLIB_PATH
    Linux. Solaris. Other System V based operating systems. LD_LIBRARY_PATH

    Set the appropriate variable for your platform in your Oracle user's .profile file. For example:

    LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/easysoft/lib:/usr/local/easysoft/unixODBC/lib
export LD_LIBRARY_PATH

    Stop and start your Oracle listener before trying to connect again.

  2. initsid.ora not configured correctly.

    You have not configured the connection to unixODBC correctly in your initsid.ora file. For examples of how to configure your initsid.ora file see these Easysoft tutorials:

    Note that although these tutorials were based around Easysoft ODBC drivers for SQL Server, the process is the same for all Easysoft ODBC drivers. If you need help configuring DGODBC/HSODBC with an Easysoft ODBC driver for a different database, please contact the Easysoft support team (). We will then create a tutorial based around your set up.

  3. 64-bit version of the Easysoft driver installed when 32-bit driver is required and vice versa.

    You may have installed the wrong version of the Easysoft software. For example:

    • If you are using Oracle 10g, you need to use a 32-bit version of the Easysoft software. Oracle 10g, including the 64-bit edition, ships with a 32-bit hsODBC interface, and so you need a 32-bit Easysoft ODBC driver.
    • If you are using a 32-bit version of Oracle 11g, you must use a 32-bit Easysoft driver even if you are running the software on a 64-bit platform.

    If you are not sure whether to use a 32-bit or 64-bit Easysoft driver, please contact the Easysoft support team (). Supply the team with this information:

    • Your Oracle version.
    • The contents of /usr/local/easysoft/product_install.info.

If, after following the guidance in this document, you are still having issues or you would like to add to this document, please send your comments to .

Notes
See Also
Applies To

Knowledge Base Feedback

* Did this content help you?
* Please select one option based on your first choice:

(* Required Fields)