RE: Accessing sql server tables from an Oracle instance
- From: "Leslie Tierstein" <leslie.tierstein@xxxxxxxxxxxxxxx>
- To: <orcl9ps8dba@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 18 Apr 2005 08:02:39 -0700
A few years ago, I used an ODBC driver from DataDirect on multiple UNIX
platforms. At the time, it may have been OEM'ed through Merant, but I
don't know if that relationship is still in effect. Performance was
fine (for an ETL application working on megabytes, not gigabytes, of
data) and installation was uneventful. =20
Leslie
=20
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mike Hennesy
Sent: Monday, April 18, 2005 10:09 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Accessing sql server tables from an Oracle instance
I was wondering if anyone has had this issue forced upon them.=20
An Oracle 9206 instance running on Solaris 8 accessing sql server 2000
tables (between 5-15).=20
What's the best way to accomplish this? I know of Oracle's Heterogeneous
services but that requires ODBC and I'm not aware of any Solaris ODBC
drivers. Has anyone used any third party ODBC drivers for Solaris
(pros/cons/how weel did they work)?=20
Is there any other method to accomplish this?=20
I'm considering installing a small oracle instance (with heterogeneous
services) on the sqlserver machine to act as a pass through to the sql
server tables.
All thoughts any opinions welcomed.
Thanks - Mike
=09
=09
__________________________________
Do you Yahoo!?=20
Yahoo! Mail - You care about security. So do we.=20
http://promotions.yahoo.com/new_mail
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
