'OraOLEDB.Oracle' provider is not registered …

Problem

You get this error when running your application:

Solution

Iron Speed Designer uses Microsoft’s “OLE DB provider for Oracle” to read the database schema. The generated applications use Microsoft’s “Oracle Client” provider. You need both of these providers on your system if you are developing with Iron Speed Designer. The deployment 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/

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, 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.