Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Accessing sql server tables from an Oracle instance

RE: Accessing sql server tables from an Oracle instance

From: Leslie Tierstein <leslie.tierstein_at_visionchain.com>
Date: Mon, 18 Apr 2005 08:02:39 -0700
Message-ID: <4AE2782C2093B34784E67971035A8160059F4537@ehost011-2.exch011.intermedia.net>


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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mike Hennesy Sent: Monday, April 18, 2005 10:09 AM
To: oracle-l_at_freelists.org
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
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Apr 18 2005 - 11:06:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US