openrowset drivers msdaora

Re: openrowset drivers msdaora


"Pachydermi tis" <dedejavu@hotma il.com> wrote in message
news:4f954dcf.0 409290901.7e383 d7f@posting.goo gle.com...[color=blue]
> Hi all,
> This should be easy, but it has me pulling my hair out.
> I have a SQL 7 server running on NT server 4 with all the patches and
> updates for both. I cannot seem to get the openrowset to run against
> an oracle server, try as I might to install the drivers from oracle.
> The first error I got said to install the drivers, so I did; now it
> says 'msdaora' bla bla TNS: could not resolve service name. I have
> tried the sql statement on another server and it works there. Does it
> have anything to do with the different 'Homes' that oracle wants to
> install it's drivers into? I have installed and uninstalled the
> drivers, different versions, different configurations at least 300
> times. What am I missing?
> Thanks for your help.
> Pachydermitis[/color]

Check out these KB articles (the second is linked from the first):




It sounds as if the Oracle client configuration is the problem - if you
can't connect with SQL Plus or some other Oracle client tool from the MSSQL
server, then you might get better answers in an Oracle group.

Simon

Re: openrowset drivers msdaora

"Simon Hayes" <sql@hayes.ch > wrote in message news:<415b0aba$ 1_1@news.bluewi n.ch>...[color=blue]
> "Pachydermi tis" <dedejavu@hotma il.com> wrote in message
> news:4f954dcf.0 409290901.7e383 d7f@posting.goo gle.com...[color=green]
> > Hi all,
> > This should be easy, but it has me pulling my hair out.
> > I have a SQL 7 server running on NT server 4 with all the patches and
> > updates for both. I cannot seem to get the openrowset to run against
> > an oracle server, try as I might to install the drivers from oracle.
> > The first error I got said to install the drivers, so I did; now it
> > says 'msdaora' bla bla TNS: could not resolve service name. I have
> > tried the sql statement on another server and it works there. Does it
> > have anything to do with the different 'Homes' that oracle wants to
> > install it's drivers into? I have installed and uninstalled the
> > drivers, different versions, different configurations at least 300
> > times. What am I missing?
> > Thanks for your help.
> > Pachydermitis[/color]
>
> Check out these KB articles (the second is linked from the first):
>
> http://support.microsoft.com/default.aspx?kbid=280106
> http://support.microsoft.com/default.aspx?kbid=259959
>
> It sounds as if the Oracle client configuration is the problem - if you
> can't connect with SQL Plus or some other Oracle client tool from the MSSQL
> server, then you might get better answers in an Oracle group.
>
> Simon[/color]

Turns out I needed an entry in one of the several tnsnames.ora file.

Re: openrowset drivers msdaora

[color=blue]
> Turns out I needed an entry in one of the several tnsnames.ora file.[/color]

Several? Sounds like you need to clean up the install!