Re: miising oracle odbc data provider



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...@xxxxxxxxxx> 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***

.



Relevant Pages

  • adsi linked servers
    ... I'm following the directions for the OLE DB Directory ... I add the linked server with this TSQL ... from OLE DB provider 'ADSDSOObject'". ... If I execute an openquery command from query analyzer I ...
    (microsoft.public.sqlserver.security)
  • RE: Monitoring and Reporting after SBS SP1
    ... I followed your instructions to remove the monitoring and then to ... In Add or Remove Programs, select Windows Small Business Server ... This provider will be run using the LocalSystem ...
    (microsoft.public.windows.server.sbs)
  • Re: Facing problem in accessing analysis service 2005 database from other machine
    ... You need to install the 9.0 OLE DB provider on the client machine. ... Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider ...
    (microsoft.public.sqlserver.olap)
  • Re: why does it say i have unsent messages in my outbox? you
    ... Windows 7 RC ... "MARIA" wrote in message ... have qwest as my email provider and internet provider. ... the proper server settings, please contact your e-mail service provider. ...
    (microsoft.public.windows.vista.mail)
  • Re: E_UNEXPECTED(0x8000FFFF) Problem with OraOleDB.Oracle
    ... migration from Windows 2000 Server to Windows 2003 Server I have ... It comes from Oracle and not from Microsoft. ... provider would be MSDAORA.Oracle. ...
    (comp.databases.oracle.misc)

Quantcast