Re: need to connect SQL Server 2k to Oracle 8.9

"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 3.2.0.0 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!
>
> Thanks,
> Andy

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 Dykstra