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.

I replied to this message in another newsgroup already, but ...

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:e8Q5xGtuFHA.1032@TK2MSFTNGP12.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.

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:3p08t0F851inU1@individual.net...
> I replied to this message in another newsgroup already, but ...
>
> 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:e8Q5xGtuFHA.1032@TK2MSFTNGP12.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.

"Steve K." <steve[remove this]@kitley.com> wrote in message
news:ODiRC6tuFHA.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:3p08t0F851inU1@individual.net...
> > I replied to this message in another newsgroup already, but ...
> >
> > 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:e8Q5xGtuFHA.1032@TK2MSFTNGP12.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.
> >
>
>

Start with DataDirect http://www.datadirect.com/products/odbc/index.ssp This
is the most widely used solution.

OpenLink http://www.openlinksw.com/ also has a driver and Easysoft has an
ODBC-ODBC bridge
http://www.easysoft.com/products/dat...dge/index.html

Be sure to do your own due diligence.

"Steve K." <steve[remove this]@kitley.com> wrote in message
news:u%23KRB15uFHA.2960@tk2msftngp13.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.
>
> "Steve K." <steve[remove this]@kitley.com> wrote in message
> news:ODiRC6tuFHA.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:3p08t0F851inU1@individual.net...
>> > I replied to this message in another newsgroup already, but ...
>> >
>> > 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:e8Q5xGtuFHA.1032@TK2MSFTNGP12.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.
>> >
>>
>>
>
>