Re: Creating DB link with SQL Server
From: <navneel.singh_at_gmail.com>
Date: Wed, 15 Apr 2009 16:54:01 -0700 (PDT)
Message-ID: <284e5c4e-791b-4028-b697-98f4b6791e98_at_d25g2000prn.googlegroups.com>
On Apr 16, 10:29 am, Michael Austin <maus..._at_firstdbasource.com> wrote:
> navneel.si..._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.- Hide quoted text -
>
> - Show quoted text -
Date: Wed, 15 Apr 2009 16:54:01 -0700 (PDT)
Message-ID: <284e5c4e-791b-4028-b697-98f4b6791e98_at_d25g2000prn.googlegroups.com>
On Apr 16, 10:29 am, Michael Austin <maus..._at_firstdbasource.com> wrote:
> navneel.si..._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.- Hide quoted text -
>
> - Show quoted text -
Thanks Michael.
But again, i knw the internet hosts thousands of such documentaion and my question merely was while iam searching it myself is anyone aware of any G-O-O-D documentation which has the same in quite simple to follow form.
Thanks again.
Cheers. Received on Wed Apr 15 2009 - 18:54:01 CDT