What is the relationship between Oracle.Web and Oracle.DataAccess in-re Asp.Net Forms Auth?

Question

I'm using oracle asp.net Forms Auth in my web app. The asp.net Membership/Role/Profile provider classes use Oracle.web.dll, and the connection string for these use Oracle.DataAccess.dll.

Now I want to change to Oracle.ManagedDataAccess.dll for the main application's data connection.

I made this change, and the app's main data connections work fine. However when any of the Forms Membership/Role/Profile methods are called, I get errors saying "Failed to load Oracle.DataAccess.dll".

I pointed the Forms Auth connections strings to a string using the Managed provider, but the Membership/Role/Profile parts seem to rely on Oracle.Web, which somehow looks for Oracle.DataAccess instead of the Oracle.ManagedDataAccess.

Can anyone shed light on this please? Thanks, --Jim

Answer 1

I ran into a similar problem and used Reflector to check references.

Yes, Oracle.Web.dll references Oracle.DataAccess.dll which further references OCI. Since OCI different for 64bit and 32bit one actually needs to install the appropriate Oracle client.

Hope that there will be a Oracle.Web version, that relies on Oracle.ManagedDataAcccess.dll soon.

The advantage of thru the use of oracle.manageddataaccess is kind of lost if one relies on profiles or membership providers.