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