Re: need to connect SQL Server 2k to Oracle 8.9
Date: Thu, 13 Mar 2008 20:33:39 GMT
"Andy" <andymilk_at_gmail.com> wrote in message news:cd99243a-ae6c-4ac7-b27a-41ce4dc47fb5_at_n77g2000hse.googlegroups.com...
> Hello all,
> I've been doing some research but haven't come up with some solid
> answers and I'm hoping you can lend a few minutes to help me out.
> I'm trying to connect to an Oracle 8.9 database.
> There are a couple ways we're exploring:
> 1. Connect to Oracle directly via ODBC
> 2. Create a "link" between SQL Server 2k and Oracle 8.9
> A couple questions:
> For option #1 above, will Oracle ODBC Rdb Release 126.96.36.199 connect to
> Oracle 8.9?
> For option #2 above, what are our options? How do we "link" these
> databases together?
> Any advice would be much appreciated!
In SQLServer you create a 'Linked Server'. You can do that easily in MS SQL
Management Studio tool.
I'm not familiar with RDB, but in 'normal' Oracle you can use Heterogeneous Services to link from Oracle to non-Oracle systems.
-- Terry DykstraReceived on Thu Mar 13 2008 - 15:33:39 CDT