Re: How to see SQL server from Oracle

From: Gump <stoopidstoopidstoopid_at_hotmail.com>
Date: 14 Feb 2005 21:37:59 -0800
Message-ID: <1108445879.007040.295420@z14g2000cwz.googlegroups.com>

Firstly, make sure you read the "Oracle9i Heterogeneous Connectivity Administrator's Guide" if you haven't already. According to this guide there are two main options:

• Oracle Transparent Gateways
• Generic Connectivity

Extract from Oracle9i Database Administrators Guide

---

The Oracle database server accesses the non-Oracle system using Oracle Heterogeneous Services in conjunction with an agent. If you access the non-Oracle data store using an Oracle Transparent Gateway, then the agent is a system-specific application.

Alternatively, you can use generic connectivity to access non-Oracle data stores so long as the non-Oracle system supports the ODBC or OLE DB protocols.

Generic connectivity enables you to connect to non-Oracle data stores by using either a Heterogeneous Services ODBC agent or a Heterogeneous Services OLE DB agent - both are included with your Oracle product as a standard feature.

The advantage to generic connectivity is that it may not be required for you to purchase and configure a separate system-specific agent. You use an ODBC or OLE DB driver that can interface with the agent. However, some data access features are only available with transparent gateway agents.

---

So if you go with the Oracle Transparent Gateway ODBC is not necessary.  Although I'm sure you can get ODBC drivers for UNIX for no cost. Have a look around on the internet, e.g. www.unixodbc.org

I haven't personally installed ODBC on UNIX before.

I would suggest trying to get the Generic Connectivity option working. It is probably more cost effective from a licensing perspective. Received on Mon Feb 14 2005 - 23:37:59 CST