The oracle Membership provider has been released or not? Inside petshp you can use oracle to store mebmership, but the mebership provider is incomplete and the sql scripts for the membership tables are not installed in the petshop source code.
It was posted by another user so you could use the converter below to convert the code, if you run into issues post it at the C# forum here you could get help to convert .NET specific classes. Hope this helps.
Your code was created to run on Oracle 10g to implement the Asp.net 2.0 provider model, the details of that are covered in the link below by the founder of Asp.net. Sorry I assumed you already know what it is and was looking for the Oracle version. Hope
this helps.
The rest of what is discussed above is for a VB solution. Running something that complex through the VB to C# translator is a recipe for headaches. If you want the C# solution go to
http://www.radicaldevelopment.net/Default.aspx and join up.
thank you for the link. I have downloaded the files. I have couple of questions. Hope you could help me!
1. I am seeing membership user class and membership class in other msdn articles as part of membership provider class. Do we need to have all the three classes, or just the membership provider class (OracleMembershipProvider.cs) is sufficient?
2. How do we start with the process of implementing this membership provider in the newly developed website?
anx721
Member
30 Points
6 Posts
Oracle membership provider
Oct 05, 2006 08:28 PM|LINK
The oracle Membership provider has been released or not? Inside petshp you can use oracle to store mebmership, but the mebership provider is incomplete and the sql scripts for the membership tables are not installed in the petshop source code.
Does anyone knows anthing? Thanks
Caddre
All-Star
26581 Points
5308 Posts
Re: Oracle membership provider
Oct 05, 2006 09:16 PM|LINK
I found this link here on this site and I found the code. Hope this helps.
http://www.ben-rush.net/source/OracleProviders/
Gift Peddie
mlasell
Member
467 Points
173 Posts
Re: Oracle membership provider
Dec 06, 2006 07:57 PM|LINK
Caddre
All-Star
26581 Points
5308 Posts
Re: Oracle membership provider
Dec 06, 2006 08:16 PM|LINK
It was posted by another user so you could use the converter below to convert the code, if you run into issues post it at the C# forum here you could get help to convert .NET specific classes. Hope this helps.
http://www.carlosag.net/Tools/CodeTranslator/Default.aspx
Gift Peddie
mlasell
Member
467 Points
173 Posts
Re: Oracle membership provider
Dec 06, 2006 08:32 PM|LINK
Here is the first step - I ran these in Toad.
CREATE
TABLE USERS(
PKID
INTEGER NOT NULL,USERNAME
VARCHAR2(255 BYTE) NOT NULL,APPLICATIONNAME
VARCHAR2(255 BYTE) NOT NULL,EMAIL
VARCHAR2(128 BYTE) NOT NULL, PASSWORD VARCHAR2(128 BYTE) NOT NULL,PASSWORDQUESTION
VARCHAR2(255 BYTE),PASSWORDANSWER
VARCHAR2(255 BYTE),ISAPPROVED
INTEGER,LASTACTIVITYDATE
DATE,LASTLOGINDATE
DATE,LASTPASSWORDCHANGEDDATE
DATE,CREATIONDATE
DATE,ISONLINE
NUMBER(1),ISLOCKEDOUT
NUMBER(1),LASTLOCKEDOUTDATE
DATE,FAILEDPASSWORDATTEMPTCOUNT
INTEGER,FAILEDPASSWORDATTEMPTWNDWSTART
DATE,FAILEDPASSWORDANSWERATTMPTCNT
INTEGER,FAILEDPASSWORDANSWERATTMPSTART
DATE)
and
ALTER
TABLE USERS ADD ( PRIMARY KEY (PKID)USING
INDEX TABLESPACE USERS PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE ( INITIAL 64K MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 ));mlasell
Member
467 Points
173 Posts
Re: Oracle membership provider
Dec 07, 2006 06:20 PM|LINK
I ran the code through the C# translator. Thanks for that link.
I saved the file as OracleMembershipProvider.cs.
Can you tell me what I am supposed to do with it now?
Thanks,
Michael
Caddre
All-Star
26581 Points
5308 Posts
Re: Oracle membership provider
Dec 07, 2006 06:41 PM|LINK
Your code was created to run on Oracle 10g to implement the Asp.net 2.0 provider model, the details of that are covered in the link below by the founder of Asp.net. Sorry I assumed you already know what it is and was looking for the Oracle version. Hope this helps.
http://weblogs.asp.net/scottgu/archive/2006/04/13/442772.aspx
Gift Peddie
mlasell
Member
467 Points
173 Posts
Re: Oracle membership provider
Dec 08, 2006 09:15 PM|LINK
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.
I won't say it is exactly easy. But after a day I did get it alll set up.
Thank you Steven Swafford.
mlasell
Member
467 Points
173 Posts
Re: Oracle membership provider
Dec 08, 2006 09:19 PM|LINK
sumathi
Member
16 Points
12 Posts
Re: Oracle membership provider
Jan 10, 2007 02:13 PM|LINK
Hi
thank you for the link. I have downloaded the files. I have couple of questions. Hope you could help me!
1. I am seeing membership user class and membership class in other msdn articles as part of membership provider class. Do we need to have all the three classes, or just the membership provider class (OracleMembershipProvider.cs) is sufficient?
2. How do we start with the process of implementing this membership provider in the newly developed website?
Warm Regards,
Sumathi R