日存档: 2010年5月17日

The 'OraOLEDB.Oracle.1' provider is not registered

error message:
The 'OraOLEDB.Oracle.1' provider is not registered
….

solution:

– Right click on the oracle_home folder (the root folder where your client is installed) and choose Properties.
– On the security tab add the local machine's Users group (or if you prefer, add the IIS and ASPNET users individually). Grant Read & Execute, List Folder Contents and Read privileges.
– Click “Apply”.
– Click “Advanced”
– Check “Replace permission entries on all child objects …”
– Click “Apply”. This will take a while to propagate the security grants down to every file and folder of the oracle client.