Re: need to connect SQL Server 2k to Oracle 8.9
Date: Fri, 14 Mar 2008 14:48:50 GMT
"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
>> Management Studio tool.
>> I'm not familiar with RDB, but in 'normal' Oracle you can use
>> 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?
Look up OpenQuery in your SQLServer documentation.
-- Terry DykstraReceived on Fri Mar 14 2008 - 09:48:50 CDT