"Tony Sebion" <tony@sebion.com> wrote in message
news:3p0h08F62unfU1@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/techinfo/tips/administration/addingoracle.mspx
> >
> > >
> > >
http://www.windowsitpro.com/SQLServer/Article/ArticleID/22264/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.
> >
> > >
>

"Steve K." <steve[remove this]@kitley.com> wrote in message
news:OX1H305uFHA.2396@TK2MSFTNGP14.phx.gbl:

> 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:3p0h08F62unfU1@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/techinfo/tips/administration/addingoracle.mspx
>
> > >
>
> > > >
> > > >
>
> http://www.windowsitpro.com/SQLServer/Article/ArticleID/22264/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.
> > >
> > > >
>
> >