The linked server is just a server configuration setting - there isn't
much to it after you've installed the Oracle driver on the SQL Server.
While you could always find a more convoluted way to access the Oracle
data, I don't know why you would want to.

Tony Sebion

"Steve K." <steve[remove this]@kitley.com> wrote in message
news:#QF6C6tuFHA.3764@TK2MSFTNGP09.phx.gbl:

> Thanks a lot Tony.
>
> One last question, you or anyone else know a driver that we could buy
> without setting up the linked server?
>
> Thanks again,
>
> Steve
>
> "Tony Sebion" <tony@sebion.com> wrote in message
> news:3p08ftF83hmhU1@individual.net...
>
> > You can connect to the Oracle server from the SQL Server by setting up a
> > linked server after installing the Oracle Client on the SQL Server.
> > Books Online contains information about linked servers, or you can check
> > these links:
> >
> >
>
> http://www.microsoft.com/sql/techinf...ingoracle.mspx
>
> >
> > http://www.windowsitpro.com/SQLServe...264/22264.html
> >
> > It looks like you can use Oracle's Heterogeneous Services (HS) to make
> > the connection the other way.
> >
> > http://techrepublic.com.com/5100-9592-5725974.html
> >
> > Good luck,
> > Tony Sebion
> >
> > "Steve Kitley" <steve@[removethis]kitley.com> wrote in message
> > news:ORKLIHtuFHA.2072@TK2MSFTNGP14.phx.gbl:
> >
>
> > > Hello,
> > >
> > > We have an instance of oracle on linux and another with sqlserver on
> > > windows.
> > >
> > > We need an odbc driver for the linux box to connect to the sql server.
> > >
> > > Does anybody have suggestions on what odbc drivers there are out there
>
> for
>
> > > linux in order for us to connect these two boxes?
> > >
> > > Thanks in advance for your help,
> > >
> > > Steve K.
>
> >

Hi Tony,

the article you sent me for connecting oracle to sql server was based on
oracle 9i being on windows box. We are not using 9i on windows, we are
using 9i (actually 10g) on linux.

Hence, I still need an odbc driver for linux in which to connect to sql
server on a windows box.

Anybody know of any linux odbc drivers?

Thanks,

Steve K.

"Tony Sebion" <tony@sebion.com> wrote in message
news:3p0h0kF849ttU1@individual.net...
> The linked server is just a server configuration setting - there isn't
> much to it after you've installed the Oracle driver on the SQL Server.
> While you could always find a more convoluted way to access the Oracle
> data, I don't know why you would want to.
>
> Tony Sebion
>
> "Steve K." <steve[remove this]@kitley.com> wrote in message
> news:#QF6C6tuFHA.3764@TK2MSFTNGP09.phx.gbl:
>
> > Thanks a lot Tony.
> >
> > One last question, you or anyone else know a driver that we could buy
> > without setting up the linked server?
> >
> > Thanks again,
> >
> > Steve
> >
> > "Tony Sebion" <tony@sebion.com> wrote in message
> > news:3p08ftF83hmhU1@individual.net...
> >
> > > You can connect to the Oracle server from the SQL Server by setting up
a
> > > linked server after installing the Oracle Client on the SQL Server.
> > > Books Online contains information about linked servers, or you can
check
> > > these links:
> > >
> > >
> >
> >
http://www.microsoft.com/sql/techinf...ingoracle.mspx
> >
> > >
> > >
http://www.windowsitpro.com/SQLServe...264/22264.html
> > >
> > > It looks like you can use Oracle's Heterogeneous Services (HS) to make
> > > the connection the other way.
> > >
> > > http://techrepublic.com.com/5100-9592-5725974.html
> > >
> > > Good luck,
> > > Tony Sebion
> > >
> > > "Steve Kitley" <steve@[removethis]kitley.com> wrote in message
> > > news:ORKLIHtuFHA.2072@TK2MSFTNGP14.phx.gbl:
> > >
> >
> > > > Hello,
> > > >
> > > > We have an instance of oracle on linux and another with sqlserver on
> > > > windows.
> > > >
> > > > We need an odbc driver for the linux box to connect to the sql
server.
> > > >
> > > > Does anybody have suggestions on what odbc drivers there are out
there
> >
> > for
> >
> > > > linux in order for us to connect these two boxes?
> > > >
> > > > Thanks in advance for your help,
> > > >
> > > > Steve K.
> >
> > >
>