Re: odbc connection with SQL Server 7.0

From: Vladimir Ivanovich <vladimiri_at_bosmedtech.com>
Date: Fri, 18 May 2001 16:45:59 -0400
Message-ID: <bSfN6.59$424.516@news.nyc.globix.net>

"KG" <karel.geraerts_at_vt4.net> wrote in message news:3b057a3e$0$9722$73bec57d_at_news.be.uu.net...
> Hello,
>
> I would like to set an odbc connection between Oracle and SQLServer 7.0.
> I would like to add records in SQLServer 7.0 using queries in Oracle !
>
> Is this possible, has someone experience with this ?
>
> Many thanks,
> Karel
>
>
>
>

Karel,
You may link Oracle server to SQL server, and then you SQL Server's pass-through queries to manipulate Oracle's data. I had to install Oracle client on SQL Server machine in order to do so. If you are familiar with SQL Server, the rest shouldn't be a problem.

HTH,
Vladimir Ivanovich
Oracle DBA
Boston Medical Technologies Received on Fri May 18 2001 - 15:45:59 CDT