RE: How to I reinstall the Microsoft OLE DB Provider for Oracle



OraOledb is not the Microsoft provider by rather the Oracle's Oracle provider.

"Tim" wrote:

> Hi,
> I am trying to setup a test connection to an Oracle database from a UDL file.
> The steps are as follows on Windows 2000 Server Service Pack 4with MDAC 2.8:
> 1) Create an empty test.txt file on the desktop
> 2) Rename to test.udl
> 3) Double click on test.udl and get the error
>
> "Provider cannot be found. Ensure that the provider has been installed
> properly."
>
> 4) I then copied in the following test into test.udl
>
> [oledb]
> ; Everything after this line is an OLE DB initstring
> Provider=OraOLEDB.Oracle.1;
>
> 5) When I double click on the file I get the Data Link Properties Box and the
> "Oracle Provider for OLE DB" entry is highlighted. However, I want to use the
> "Microsoft OLE DB Provider for Oracle" provider so when I select this entry
> and then press the Next button I get the error:
> "Provider is no longer available. Ensure that the provider has been
> installed properly."
>
> Incidently, I get the same error the following other Microsoft providers
> "Microsoft OLE DB Provider for DTS Packages"
> "Microsoft OLE DB Provider for Internet Publishing"
> "Microsoft OLE DB Provider for ODBC Drivers" and
> "Microsoft OLE DB Provider for SQL Server" but NOT for
> "Microsoft OLE DB Provider for Indexing Services" or
> "Microsoft OLE DB Provider for Simple Provider"
>
> How do I reinstall the Microsoft OLE DB Provider for Oracle?
> Thanks
> Tim
>
.