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

---

Yes.

You can use the OOB to access remote ODBC drivers from Oracle e.g. MS SQL Server or MS 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 11g and Oracle 10g:
  • Accessing SQL Server from Oracle with Database Gateway for ODBC (DG4ODBC)
  • Accessing ODBC Databases from Windows with Oracle Database Gateway for ODBC (DG4ODBC)
• For Oracle 9i and Oracle 8i:
  • Accessing ODBC and JDBC Data Sources from Oracle Heterogeneous Services (hsODBC).

Many of our customers have used OOB under DG4ODBC/hsODBC to connect their Oracle database to many other remote databases like MS SQL Server.

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 OOB's connection attribute DisguiseWide to 1 because hsodbc does not seem to understand SQL_C_Wxxx types. See Why do I get error "table or view does not exist" when connecting Oracle hsODBC to SQL Server?

Applies To

• Products
  • Easysoft ODBC-ODBC Bridge
• Applications
  • Oracle