Oracle membership provider

Last post 09-08-2009 7:47 AM by jem3hall. 28 replies.

Sort Posts:

  • Oracle membership provider

    10-05-2006, 4:28 PM
    • Member
      30 point Member
    • anx721
    • Member since 09-19-2006, 9:34 AM
    • Posts 6

    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

  • Re: Oracle membership provider

    10-05-2006, 5:16 PM
    • All-Star
      26,551 point All-Star
    • Caddre
    • Member since 06-23-2003, 9:53 AM
    • Indy
    • Posts 5,308

    I found this link here on this site and I found the code.  Hope this helps.

    http://www.ben-rush.net/source/OracleProviders/

    Kind regards,
    Gift Peddie
  • Re: Oracle membership provider

    12-06-2006, 3:57 PM
    • Member
      466 point Member
    • mlasell
    • Member since 09-22-2006, 4:13 PM
    • Posts 169
    Anything in C#?
  • Re: Oracle membership provider

    12-06-2006, 4:16 PM
    • All-Star
      26,551 point All-Star
    • Caddre
    • Member since 06-23-2003, 9:53 AM
    • Indy
    • Posts 5,308

    mlasell:
    Anything in C#?

    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

    Kind regards,
    Gift Peddie
  • Re: Oracle membership provider

    12-06-2006, 4:32 PM
    • Member
      466 point Member
    • mlasell
    • Member since 09-22-2006, 4:13 PM
    • Posts 169

    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

    ));
  • Re: Oracle membership provider

    12-07-2006, 2:20 PM
    • Member
      466 point Member
    • mlasell
    • Member since 09-22-2006, 4:13 PM
    • Posts 169

    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

  • Re: Oracle membership provider

    12-07-2006, 2:41 PM
    • All-Star
      26,551 point All-Star
    • Caddre
    • Member since 06-23-2003, 9:53 AM
    • Indy
    • Posts 5,308

    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

    Kind regards,
    Gift Peddie
  • Re: Oracle membership provider

    12-08-2006, 5:15 PM
    • Member
      466 point Member
    • mlasell
    • Member since 09-22-2006, 4:13 PM
    • Posts 169

    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.

  • Re: Oracle membership provider

    12-08-2006, 5:19 PM
    • Member
      466 point Member
    • mlasell
    • Member since 09-22-2006, 4:13 PM
    • Posts 169
    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.
  • Re: Oracle membership provider

    01-10-2007, 10:13 AM
    • Member
      16 point Member
    • sumathi
    • Member since 12-29-2006, 6:12 PM
    • Posts 12

    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

  • Re: Oracle membership provider

    01-10-2007, 10:13 AM
    • Member
      16 point Member
    • sumathi
    • Member since 12-29-2006, 6:12 PM
    • Posts 12

    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,
    RS

  • Re: Oracle membership provider

    01-10-2007, 1:39 PM
    • Member
      16 point Member
    • sumathi
    • Member since 12-29-2006, 6:12 PM
    • Posts 12

    Can you please indicate the steps you have done to set this OracleProvider up?

    Thanks,
    RS

  • Re: Oracle membership provider

    01-12-2007, 3:51 PM
    • Member
      466 point Member
    • mlasell
    • Member since 09-22-2006, 4:13 PM
    • Posts 169

    I posted some info about this:

    http://forums.asp.net/thread/1209999.aspx

    If you still have questions, ask away - though my memory is stating to recede here.

    Michael

  • Re: Oracle membership provider

    01-17-2007, 12:07 PM
    • Member
      16 point Member
    • sumathi
    • Member since 12-29-2006, 6:12 PM
    • Posts 12

    Michael,

    Thanks for your support so far. I ran into another issue. Please let me know if you are aware of the problem/solution. Thankx once again.

    Steps I followed:

    1. I have set up the membership schema in Oracle Database

    2. I have modified the config file to refer to the oracle membership provider

    3. I have set up the front end with the sample login pages

     

    I am getting a type initializer error with Oracle.DataAccess.dll.  

     

    1. I used the dll provided with RAdical development. I get the following error

     

    Provider is not compatible with Oracle Client version

     

    The provider is not compatible with the version of Oracle client

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: Oracle.DataAccess.Client.OracleException: The provider is not compatible with the version of Oracle client

     

     

    2. I removed this dll from the project, and added the Oracle.dataacess.dll which was present in my machine (ODP.net), I get the following mismatch error.

     

    Could not load file or assembly 'Oracle.DataAccess, Version=2.102.2.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)

     

    I am positive that the error is due to the Oracle DataAccess dll. But how do I fix this one. Which dll should I use? If I use the radical, i get the type mismatch error. If i use the ODP.net provided dll, I get the could not load file error.  I am confused at this stage.

     

    Thank you very much for your support. I appreciate your help!

     

    Warm Regards,
    RS

  • Re: Oracle membership provider

    01-18-2007, 11:10 AM
    • Member
      466 point Member
    • mlasell
    • Member since 09-22-2006, 4:13 PM
    • Posts 169

    Did you download the latest oracle client?

    Michael

Page 1 of 2 (29 items) 1 2 Next >