RE: Accessing sql server tables from an Oracle instance
- From: "Goulet, Dick" <DGoulet@xxxxxxxx>
- To: <orcl9ps8dba@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 18 Apr 2005 10:19:49 -0400
Get a copy of Oracle's transparent gateway, otherwise known as
Enterprise Integration Gateways.
-----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
__________________________________=20
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:
