Re: Creating DB link with SQL Server
From: Michael Austin <maustin_at_firstdbasource.com>
Date: Wed, 15 Apr 2009 17:29:54 -0500
Message-ID: <QbtFl.4946$im1.3003_at_nlpi061.nbdc.sbc.com>
navneel.singh_at_gmail.com wrote:
> On Apr 15, 10:09 pm, IM <i..._at_ianmurphy.freeserve.co.uk> wrote:
>
> Is anyone aware of any good online documentation that i can use to
> connect from SQL Server 2000 to Oracle 10G (residing on a 64 bit linux
> system). I found few documentation on transparent gateways which
> allows vice versa connection. Would be gratefull if anyone can point
> me on how i can connection from SQL Server as well.
>
> Thanks.
Date: Wed, 15 Apr 2009 17:29:54 -0500
Message-ID: <QbtFl.4946$im1.3003_at_nlpi061.nbdc.sbc.com>
navneel.singh_at_gmail.com wrote:
> On Apr 15, 10:09 pm, IM <i..._at_ianmurphy.freeserve.co.uk> wrote:
>> On Apr 15, 9:11 am, yossarian <yossaria..._at_operamail.com> wrote: >> >>> Mladen Gogala wrote: >>>>> Just to add to it, the oracle DB is installed on a linux platform >>>> And on which platform is SQL Server installed? Just kidding, we all know >>>> that there can be only one, as in Highlander. You can buy a transparent >>>> gateway for SQL Server and Oracle will allow you to create a DB link >>>> pointing to SQL Server >>> You may also want to try a free solution using Oracle Heterogeneous >>> Services, UnixODBC and FreeTDS (http://www.freetds.org/) and see if it >>> fit your needs. >>> Y. >> You can also go from SQL Server to Oracle with "Linked Servers" in SQL >> Server. May not be what you are after but it's there for you anyway. >> >> Cheers, >> >> IM
>
> Is anyone aware of any good online documentation that i can use to
> connect from SQL Server 2000 to Oracle 10G (residing on a 64 bit linux
> system). I found few documentation on transparent gateways which
> allows vice versa connection. Would be gratefull if anyone can point
> me on how i can connection from SQL Server as well.
>
> Thanks.
did you read any of the previous post where we recommended DTS
here LET ME GOOGLE THAT FOR YOU...
http://lmgtfy.com/?q=SQL+SERVER+DTS+connect+oracle
If you have trouble figuring this out you may rethink your chosen career path. Received on Wed Apr 15 2009 - 17:29:54 CDT