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 <william.or...@rodale.com> 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***