Hi all,
Thanks for the help, did not find the problem, however both instances are
able to connect now, starting last nite.... no changes made. Web Admin
suggests drivers locked in memory... maybe so.
Go figger... Still clueless as to why this one server is having such bizarre
behavior. We'll wait for it to re-occur.



-----Original Message-----
From: Chip Smith
[mailto:mssqldba-ezmlmshield-x64184562.[Email address protected]
Sent: Monday, October 04, 2004 12:57 PM
To: LazyDBA Discussion
Subject: Unpredictable Linked Servers


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


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]


MS Sql Server LazyDBA home page