Hi Gurus, This is a question that I may have asked in the past on another forum I think it was not the right forum well here goes... I have an instance of sqlserver2005 64 bit and I need to be able to link it to an oracle 11g server for the transfer of data in all of the other instances there is an oracle link priver listed in the area where you add a linked server in this instance it is not listed there for I can not get reporting services as well as linked servers functionality to work are there any suggestions as how to get this oracle provider added without reinstalling the server there are to many processes running on this server to redo it ?? Bill_Orova *** Sent via Developersdex http://www.developersdex.com ***
Hello Bill, I am aware of my colleagues troubleshooting a similar architecture. They believe that there is no 64bit OLE DB Provider available for 64bit Windows systems. Likewise, there does not appear to be a readily available 64bit Microsoft OLE DB Provider (MSDASQL). I believe that this provider will be available to a Service Pack 3 to its Windows Server 2003 O/S, and I believe it will be generally distributed with Windows Server 2008. You may want to check for a beta for your O/S or wait for an upgrade path. In the interim, OpenLink Software has 64bit OLE DB providers for this architecture. On Apr 3, 12:07 pm, Bill Orova wrote: > Hi Gurus, > This is a question that I may have asked in the past on another forum I > think it was not the right forum well here goes... I have an instance of > sqlserver2005 64 bit and I need to be able to link it to an oracle 11g > server for the transfer of data > in all of the other instances there is an oracle link priver listed in > the area where you add a linked server in this instance it is not listed > there for I can not get reporting services as well as linked servers > functionality to work are there any suggestions as how to get this > oracle provider added without reinstalling the server there are to many > processes running on this server to redo it ?? > Bill_Orova > > *** Sent via Developersdexhttp://www.developersdex.com***
