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:
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.
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:
/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 .
isql
does 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 isql
.Oracle is a registered trademark of Oracle Corporation and/or its affiliates.