MDAC 2.8 win 2003 x64 Ole Db Problem

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

We have installed the following:

WIN Server 2003 Enterprise x64 Edition
SQL Server 2005 CTP


The MS OLE DB Provider for Oracle (MSDAORA.dll) doesn't show up in a list of
OLE DB providers available for linked servers in SQL 2005.
Also, it doesn't show up in a list of providers when trying to test using a
..udl file.



I ran Component Checker 2.0 for MDAC 2.8 for SP2 and it doesn't show any
errors and it does show MSDAORA.dll in the files section,
but can't see any entry in the Com section (not sure if there should be) or
the registry section there isn't a key for MSDAORA.dll.

I ran regsvr32.exe to unregister then register MSDAORA.dll and it reported
successful on each, but still no registry entries

I would start checking my Oracle Client installation (Oracle Client 10g) but
it doesn't appear to be connectivity, its just that the ole db provider
doesn't show up on the list to even test it.

Please advise any ideas.
tks
--
SMoss
.

Relevant Pages

  • Cant get Oracle OLE DB provider to work from SSIS on a 64-bit environment
    ... I posted this question in the .server newsgroup yesterday, but apparently my cross-post to this newsgroup didn't made it, so now I post it once more. ... I'm having some troubles setting up an Oracle datasource on a SSIS ... Since this Provider isn't available in the 64-bit version I ... I'd love to uninstall both Oracle clients and then try just to install ...
    (microsoft.public.sqlserver.dts)
  • Re: Oracle Linked Servers
    ... To use distributed transactions with the Oracle OLE DB Provider in your ... I created a blank database in sql server ...
    (microsoft.public.sqlserver.server)
  • Re: Oracle Database Access via IIS 6.0 ASP Pages on Windows 2003 S
    ... communicate back through IIS to SQL*NET installed for the Oracle Client. ... Microsoft SQL Server 2000 Standard with SP3a installed on same box. ... Microsoft OLE DB Provider for ODBC Drivers error '80004005' ...
    (microsoft.public.inetserver.iis)
  • SQL Server 2005 64 bit OLE DB provider for Oracle wont install
    ... WIN Server 2003 Enterprise x64 Edition ... The MS OLE DB Provider for Oracle doesn't show up in a list of ... OLE DB providers available for linked servers in SQL 2005. ... it doesn't appear to be connectivity, its just that the ole db provider ...
    (microsoft.public.sqlserver.xml)
  • 2nd post as no replies: MDAC 2.8 wont install on 64 bit Win2003 E
    ... WIN Server 2003 Enterprise x64 Edition ... The MS OLE DB Provider for Oracle doesn't show up in a list of ... OLE DB providers available for linked servers in SQL 2005. ... it doesn't appear to be connectivity, its just that the ole db provider ...
    (microsoft.public.data.oledb)