RE: connecting Oracle to SQL Server
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
- Date: Fri, 8 Aug 2008 15:15:34 -0400
The gateway product costs extra.
HS or generic connectivity requires the use of an ODBC driver for the
database server platform designed to access SQL Server. The only
platform I believe that comes with such a driver is Windows so extra
cost is probably required unless you are capable of writing your own
ODBC program.
On the other hand the Oracle client for Windows is free and MS on 32 bit
systems provides ODBC/OLE drivers to Oracle. For 64 bit Windows you
need the Oracle 64 bit OLE driver. Pushing and pulling from the SQL
Server side is free.
-- Mark D Powell --
Phone (313) 592-5148
________________________________
From: Jeffrey Beckstrom [mailto:JBECKSTROM@xxxxxxxxx]
Sent: Friday, August 08, 2008 3:01 PM
To: Powell, Mark D
Subject: RE: connecting Oracle to SQL Server
Are they extra costs options?
>>> "Powell, Mark D" <mark.powell@xxxxxxx> 8/8/08 2:48 PM >>>
Look into Generic Connectivity and Heterogeneous Services on
metalink. Also the Oracle product: Transparent Open Gateway.
-- Mark D Powell --
Phone (313) 592-5148
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jeffrey Beckstrom
Sent: Friday, August 08, 2008 1:54 PM
To: oracle-l-freelists; oracle-db-l
Subject: connecting Oracle to SQL Server
Isn't possible to access a SQL Server database from
within an Oracle database. If true, can someone point me in the right
direction.
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
---------------------------------------------------------------------
Scanning of this message and addition of this footer is performed
by SurfControl E-mail Filter software in conjunction with
virus detection software.
Other related posts:
