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

"Andy" <andymilk_at_gmail.com> wrote in message news:548de90b-1826-414d-ac9d-b4576b55c65f_at_d45g2000hsc.googlegroups.com...
> >
>> 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
>
> Hi Terry,
>
> Thanks for the help.
>
> I won't have any control of the Oracle database, so I basically need
> to use ODBC or SQL Server to connect to it. Once SQL server is
> "linked", can I talk to the ODBC connection that is connected to my
> SQL Server, and query data from the Oracle linked server?
>
> I need to pull data from Oracle, insert it into SQL Server tables, and
> then access that data with ColdFusion. Can I write queries that
> execute on a schedule to pull data from Oracle and insert into SQL
> Server tables?
>
> Thanks,
> Andy

Look up OpenQuery in your SQLServer documentation.

-- 
Terry Dykstra