Easysoft ODBC-ODBC Bridge

Can I use the OOB with Oracle's heterogeneous services (DG4ODBC/hsODBC)?

Article:
00924
Last Reviewed:
11th July 2008
Revision:
2

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:

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

Knowledge Base Feedback

* Did this content help you?
* Please select one option based on your first choice:

(* Required Fields)


Oracle is a registered trademark of Oracle Corporation and/or its affiliates.