Connect Oracle to SQL Server
Oracle Tips by Burleson Consulting

QUESTION: How do I
connect Oracle to SQL Server?

Here is an article I wrote on Hetergeneous Services.
In order to connect to SQL*Server from Oracle, you
must do several things:

1. Install ODBC drivers for the SQL*Server database.
The drivers are installed on your laptop or on
the server that contains the Oracle code tree.
2. Setup the ODBC connection on your laptop using
the Windows ODBC Data Source Administrator
3. Test the ODBC drivers to ensure that connectivity
is made to the non-Oracle database.
4. Ensure the Global_names parameter is set to False
in the Oracle database.
5. Configure the Hetergeneous services. This
consists of creating an initodbc.ora file within the
Oracle
Oracle database installation.
7. Modify the Listener.ora file on the database
installation to connect to the Oracle instance and
ODBC drivers.
8. Modify the Tnsnames.ora file to point to the
proper code tree.
9. Reload the listener
10. Create a database link on the Oracle
installation.
11. Run a Select statement for the Oracle
installation using the database link.

Note:This Oracle
documentation was created as a support and Oracle training reference for use by our
DBA performance tuning consulting professionals.
Feel free to ask questions on our
Oracle forum.

Verify
experience!Anyone
considering using the services of an Oracle support expert should
independently investigate their credentials and experience, and not rely on
advertisements and self-proclaimed expertise. All legitimate Oracle experts
publish
their Oracle
qualifications.

Errata? Oracle technology is changing and we
strive to update our BC Oracle support information. If you find an error
or have a suggestion for improving our content, we would appreciate your
feedback. Just e-mail:
and include the URL for the page.