September 13, 2010 at 1:59 pm
I am running sql server 2005sp2 on a windows 2003 clustered environment 64 bit. I am trying to setup a linked server but I am having problems. I had no issue on a standalone 32bit vm. However now I have installed the v2 64 bit client and the v2 ODAC restarted the instance, but no oracle providers are showing up under linked servers. I verified the client was working correct I was able to sqlplus to the oracle database from the machine no problem. I have tryed failing over to the passive node after a fresh install over there no good.. I tried uninstalling and reinstalling the 32bit oracle client ( I read that solved someones problem once) still no good. I can not get anything to populate additional providers to be used. Please help drive myself nuts!
September 13, 2010 at 4:06 pm
Please check if this link helps
http://www.mssqltips.com/tip.asp?tip=1433
Thank You,
Best Regards,
SQLBuDDY
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply