I am trying to set up the oracle membership provider for my web app.
I am using Oracle XE
My application connects to my database just fine.I ran all of the oracle scripts to create the Oracle provider etc.However if i try to login to the site or create a user, anything that uses the provider etc I always get this error
Could not load file or assembly 'Oracle.DataAccess, Version=2.111.7.20, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies.The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) Odd thing is I am using the Oracle data access in my connection string and it works fine for quering the database etc. I set up a query for the ora users table and it worked fine even used it in a gridview the same connection string that is below.It just doesn't work with the oracle membership provider or some other issue I am missing... I have the oracle.web.dll in my Bin Folder and it is Version=2.111.7.20
Here are my relevent lines from my web.config
+<membership defaultProvider="OracleProvider">
<providers>
+ <remove name="OracleProvider"/>+
+ <add name="OracleProvider" connectionStringName="OraAspNetConString" type="Oracle.Web.Security.OracleMembershipProvider,Oracle.Web"/>+
+ </providers>+
+ </membership>+
+ <profile>+
+ <providers>+
+ <remove name="AspNetOracleProfileProvider"/>+
+ <add name="AspNetOracleProfileProvider" connectionStringName="OraAspNetConString" applicationName="/" type="Oracle.Web.Profile.OracleProfileProvider,Oracle.Web"/>+
+ </providers>+
+ </profile>+
+ +
+ <roleManager defaultProvider="AspNetOracleRoleProvider">+
+ <providers>++
+ <remove name="AspNetOracleRoleProvider"/>+
+ <add name="AspNetOracleRoleProvider" type="Oracle.Web.Security.OracleRoleProvider,Oracle.Web" connectionStringName="OraAspNetConString" applicationName="/"/>++
+ </providers>+
+ </roleManager>+
+<connectionStrings>+
+<add name="OraAspNetConString" connectionString="Data Source=xe;Persist Security Info=True;User ID=myusername;Password=mypassword;Unicode=True" 3. providerName="Oracle.DataAccess" />++
+</connectionStrings>+
I have tried using the config lines for the providers with the "Culture=neutral, # PublicKeyToken=89b483f429c47342" Version="2.111.7.20"/" and without them I get the same error.
My DLL is in the bin directory of the website, and I can actually query the users table with .net using the above connection string as well.
The provider just won't work..