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

---

If you are running an Oracle database on a UNIX or Linux platform and want to read/write data in a remote MS SQL Server database you can use Oracle's heterogeneous services (DG4ODBC/hsodbc) and the SQL Server ODBC Driver.

Oracle's Heterogeneous services allows you to use Oracle SQL to transparently access data stored in non-Oracle systems as if the data resides within an Oracle server.

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)
• For Oracle 9i and Oracle 8i:
  • Accessing ODBC and JDBC Data Sources from Oracle Heterogeneous Services (hsODBC).

Download the ODBC driver for SQL Server

You can also use the ODBC-ODBC Bridge to connect to any remote Windows database from Oracle.

You can find other ODBC Drivers that you can use with Oracle's heterogeneous services here.

Applies To

• Products
  • Easysoft ODBC-SQL Server Driver
• Databases
  • Microsoft SQL Server
• Applications
  • Oracle