Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Dec 14, 2006 09:22 PM|LINK
For C sharpies:
I found the whole solution at
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:
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:
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.