Can I use the ODBC-ODBC Bridge with Oracle's Heterogeneous Services (DG4ODBC or HSODBC)?

Yes. You can use the Easysoft ODBC-ODBC Bridge to access remote ODBC drivers from Oracle. For example, Microsoft SQL Server or Microsoft Access. This allows you to exchange data between Oracle and other databases.

You can find detailed instructions on how to set this up in the following articles:

• For Oracle 10g and later:
  • Accessing SQL Server from Oracle with Database Gateway for ODBC (DG4ODBC)
  • Accessing ODBC data sources with Oracle Database Gateway for ODBC (DG4ODBC) on Windows
• For Oracle 9i and Oracle 8i:
  • Accessing ODBC and JDBC data dources from Oracle Heterogeneous Services (HSODBC).

Notes

1. hsodbc is a 32-bit application. You need to use it with a 32-bit Easysoft ODBC driver. For 64-bit platforms, choose the 32-bit version of the driver even when there's a 64-bit version available. 32-bit drivers will still function correctly on a 64-bit platform.
2. You may need to set ODBC-ODBC Bridge's connection attribute DisguiseWide to 1, because HSODBC doesn't support SQL_C_Wxxx types. Refer to Why do I get error "table or view does not exist" when connecting Oracle HSODBC to SQL Server?