"Pachydermitis" <dedejavu@hotmail.com> wrote in message
news:4f954dcf.0409290901.7e383d7f@posting.google.com...
> 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

"Simon Hayes" <sql@hayes.ch> wrote in message news:<415b0aba$1_1@news.bluewin.ch>...
> "Pachydermitis" <dedejavu@hotmail.com> wrote in message
> news:4f954dcf.0409290901.7e383d7f@posting.google.com...
> > 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
>
> 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

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