Easysoft.com Documentation Knowledge Base Products  |  Solutions  |  Support  |  Applications  |  Developer  |  Company

---

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:

   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. 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:

   • DG4ODBC
   • HSODBC

   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 (support@easysoft.com). 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 (support@easysoft.com). 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 support@easysoft.com.

Notes

• Successfully testing the Easysoft ODBC driver with 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.
• Restarting or reloading the Oracle listener will not re-read the Oracle .ora files or disconnect any links. You must STOP and START your Oracle listener for any changes you have made to take effect.

See Also

• Accessing SQL Server from Oracle with Database Gateway for ODBC (DG4ODBC)
• Accessing ODBC and JDBC Data Sources from Oracle Heterogeneous Services (HSODBC)
• 64-bit ODBC

Applies To

• Products
  • Easysoft ODBC-Oracle Driver
  • Easysoft ODBC-InterBase Driver
  • Easysoft ODBC-Sybase Driver
  • Easysoft ODBC-ODBC Bridge
  • Easysoft ODBC-Firebird Driver
  • Easysoft ODBC-SQL Server Driver
  • Easysoft ODBC-Oracle WP Driver
  • Easysoft ODBC-Access Driver
• Applications
  • Oracle