You need to join to download his excellent Community project for creating an entire Oracle Membership database, stored procedures and C# files.
He is still working on the Roles db tables and procedures.
I won't say it is exactly easy. But after a day I did get it all set up. I followed the Instructions in his ReadME.Doc
Thank you Steven Swafford.
Here are some of the issues I ran into.
I already hadOracle installed,
I had to download and install ODP.NET for Oracle 10gR2.
I ran his SQL code(create_database.sql in PLSQL in the downoaded code) chunk by chunk in the Toad SQL editor, removing ".Portal" from anywhere in the code, since I didn't have permissions to create a package. The stored procedures creation had to be run
as a script. Perhaps the whole thing could have been run as a script.
Once the database was set up:
I opened the website in Visual Studio
I created a folder called Bin in the website root.
added the dlls and clicked on Website:Add reference.
mlasell
Member
467 Points
173 Posts
Re: Re:Re: About the membership provider
Dec 14, 2006 09:22 PM|LINK
For C sharpies:
<div class=ForumPostContentText id=ctl00_ctl01_bcr_ctl00___PostRepeater_ctl08_PostViewWrapper>I found the whole solution at http://www.radicaldevelopment.net/Default.aspx
You need to join to download his excellent Community project for creating an entire Oracle Membership database, stored procedures and C# files.
He is still working on the Roles db tables and procedures.
I won't say it is exactly easy. But after a day I did get it all set up. I followed the Instructions in his ReadME.Doc
Thank you Steven Swafford.
Here are some of the issues I ran into.
I already hadOracle installed,
I had to download and install ODP.NET for Oracle 10gR2.
I ran his SQL code(create_database.sql in PLSQL in the downoaded code) chunk by chunk in the Toad SQL editor, removing ".Portal" from anywhere in the code, since I didn't have permissions to create a package. The stored procedures creation had to be run as a script. Perhaps the whole thing could have been run as a script.
Once the database was set up:
I opened the website in Visual Studio
I created a folder called Bin in the website root.
added the dlls and clicked on Website:Add reference.
These are the .dlls that are there:
Oracle.DataAccess.dll
RadicalDevelopment.Helper.dll
RadicalDevelopment.OracleMembership.dll
RadicalDevelopment.OracleSiteMap.dll
I think only the first and third are really neccessay for Oracle membership.
Per his instructions I added this and the Oracle Connection String to web.config:
<
compilation debug="true"><
assemblies><
add assembly="System.Data.OracleClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/><
add assembly="Oracle.DataAccess, Version=2.102.2.20, Culture=neutral, PublicKeyToken=89B483F429C47342"/><
add assembly="System.Transactions, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/><
add assembly="System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/><
add assembly="System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/><
add assembly="System.Configuration, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/><
add assembly="System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/><
add assembly="System.Xml, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/><
add assembly="System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/><
add assembly="System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/></
assemblies></
compilation><
membership defaultProvider="OracleProvider"><
providers><
remove name="AspNetSqlMembershipProvider"></remove><
add connectionStringName="BEXWEB" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true" applicationName="Radical Development" requiresUniqueEmail="true" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="4" minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10" passwordStrengthRegularExpression="" name="OracleProvider" type="RadicalDevelopment.OracleMembership.OracleMembershipProvider"/></
providers></
membership>You can use his aspx files for creating users etc contained in the Web folder of the dowwnloaded code.
I don't know if that will confuse more than help, but maybe you will find something in it that helps.
Michael
</div>