Linking to Oracle 8i using OLE DB Provider

[Jerry Mounce]

When I use the Link Table Wizard all is well till the end
when I get an error message:

Oracle OLE DB Provider_
OLE DB error trace [Non-Interface error: Provider not
registered]

Microsoft OLE DB Provider for Oracle_
OLE DB error trace [OLE/DB Provider 'MSDORA.1'
IUnknown::QueryInterface returned 0x80070005: Access
Denied]

Has anyone seen this before or maybe make a recomendation
to which Oracle Provider will work?

Thanks,

Jerry

 

[Joe Fallon]

I use the MS ODBC driver for Oracle.
Over 5 years with no trouble at all.