Here we are;
One server win2k, with 4 procs, 4g mem.
Named Instance 1 has a linked server connected to Oracle, no probs,
resultsets return as expected.
Named Instance 2 on same box says, "OLE DB provider 'MSDAORA' reported an
error.
[OLE/DB provider returned message: Oracle client and networking components
were not found. These components are supplied by Oracle Corporation and are
part of the Oracle Version 7.3.3 or later client software installation."
Same logins, same query's. (select * from xxx..ORACLE.DBTABLENAME) Fails on
one, works for the other. All mdac is current. SP3a loaded. Oracle client 9i
re-loaded. Box has been rebooted 12 to 15 times in the process of unloading
and reloading sp's, mdac, oclients, etc....

Does anybody know how to troubleshoot this? All the reg entries are
identical. Is this an expected behavior? If we can ever get set up to be
able to repeatable connects to this Oracle box (which by the way, every
other sql server in my shop connects succesfully to), I could get this stuff
done , and Oracle could be made to go away.....

Any feedback might help.

-- chip

MS Sql Server LazyDBA home page