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:
25th January 2010
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 not set for Easysoft 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:

    PlatformEnvironment variable
    AIXLIBPATH
    HP-UXSHLIB_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. init<sid>.ora not configured correctly.

    You have not configured the connection to unixODBC correctly in your init<sid>.ora file. For examples of how to configure your init<sid>.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 versions of Oracle®, ship 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)


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