How do I connect Oracle to Microsoft SQL Server?

If you're running an Oracle database on a UNIX or Linux platform and want to read or write data in a remote SQL Server database, you can use Oracle's Heterogeneous Services (DG4ODBC or 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 was stored on an Oracle server.

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

• For Oracle 10g–23c:
  • Accessing SQL Server from Oracle with Database Gateway for ODBC (DG4ODBC)
• For Oracle 8i–9i:
  • Accessing ODBC and JDBC data dources 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 dDrivers that you can use with Oracle's Heterogeneous Services here.

• About Easysoft

• Contact us
• About us
• Clients
• Blog
• Careers

• Products

• ODBC drivers
• JDBC drivers
• Bridges and gateways
• In development

• Services

• Consultancy
• Training
• Custom development

• Licensing

• Product licenses
• Prices

• Support

• Support home
• Solution wizard
• Getting Started Guides
• User Guides
• Knowledge Base

• Search

• Easysoft.com
• Documentation
• Knowledge Base

• Popular Resources

• Developer area
• Client applications

• Legal

• Privacy statement

© 1993 - 2024 Easysoft Limited. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other trademarks and registered trademarks appearing on easysoft.com are the property of their respective owners.

• 
• 
•