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:
The environment variable you use to set the library search path varies:
|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.
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.
You may have installed the wrong version of the Easysoft software. For example:
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:
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 .
isqldoes not mean that the driver will work with HSODBC/DG4ODBC. You need to use the correct version of the driver (32-bit or 64-bit, as discussed earlier) and to test that driver with
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.