OraOLEDB.Oracle provider is not registered ...

Problem

You get this error when running your application:

Error Connecting To Database

Unable to connect to XXX server. Error: The 'OraOLEDB.Oracle' provider is not registered on the local machine...

Iron Speed Designer uses Microsoft’s “OLE DB provider for Oracle” to read the database schema. Applications use Microsoft’s “Oracle Client” provider. You need both of these providers on your system if you are developing with Iron Speed Designer. Your production system only needs Microsoft’s Oracle Client. (The OLE DB provider is used by Iron Speed Designer because it provides additional functionality used to read and understand the database schema.)

For details, see:

http://forums.oracle.com/forums/thread.jsp?forum=148&thread=214089&tstart=0&trange=15

http://www.orafaq.com/forum/t/38330/0/

Setting ASPNET User Permissions

If you already have the appropriate providers, check the permissions as described below:

Check if ASPNET user has permissions on the folder where Oracle client is installed. Specifically, open Microsoft Windows Explorer and go to the Oracle client folder and check to see if ASPNET user is listed. If the ASPNET user is listed, make sure it has Full permissions, click Apply, and then click OK.

If ASPNET is not listed, click Add, and then choose your machine name from the Look In menu. Select ASPNET, click Add, and then click OK. Give the user/group Full permissions in addition to the default permissions it is added with, click Apply, and then click OK.

Make sure permissions are applied to all sub-folders and files of the application folder.

Setting Oracle Home Folder Permissions

Step 1: Log on to Microsoft Windows as a user with Administrator privileges.

Step 2: Launch Windows Explorer and navigate to the ORACLE_HOME folder.

Step 3: Right-click on the ORACLE_HOME folder and choose the “Properties” option.

Step 4: Click on the “Security” tab of the “Properties” window.

Step 5: Click on “Authenticated Users” item in the “Name” list.

Step 6: Uncheck the “Read and Execute” box in the “Permissions” list.

Step 7: Re-check the “Read and Execute” box you just unchecked).

Step 8: Click the “Advanced” button and in the “Permission Entries” list make sure you see the “Authenticated Users” listed there with: Permission = Read & Execute Apply To = This folder, subfolders and files Make sure the “Apply onto” drop-down box is set to “This folder, subfolders and files”.

Step 9: Click the “Ok” button until you close out all of the security properties windows.

Step 10: You must REBOOT your machine.

Step 11: Re-start Iron Speed Designer and your application.

Running applications using Microsoft IIS 7 on a 64 bit machine

Applications connecting to an Oracle database server should run in an Application Pool configured with ‘Enable 32-Bit Applications’ = True. This requires Oracle 32-bit drivers to be installed on the running system. Use the IIS Manger to verify your application’s Application Pool.

In the Connections pane, select your application:

Click ‘Advanced Settings’ and verify the application pool used by your application.

Then select that application pool in the connection pane:

Click ‘Advanced Settings’ and be sure that ‘Enable 32-bit Applications’ is True.