About the membership provider RSS

• • Reply
  

  Caddre

  All-Star

  26581 Points

  5308 Posts

  Re: Re:Re: About the membership provider

  Dec 14, 2006 12:42 AM|LINK

  epimentel

  Can you send it to me too? pimentele@sbcglobal.net

  Thanks a lot.

  Try this thread for the VB version download and instructions of where to download the C# version.  Hope this helps.

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

  Kind regards,
  Gift Peddie
• • Reply
  

  epimentel

  0 Points

  9 Posts

  Re: Re:Re: About the membership provider

  Dec 14, 2006 01:50 AM|LINK

  Thank you very much.

   I'm new to the forum and also to Visual Studio .NET.  It may be obvious, but I got the code and I don't know how to make VS see the new provider.

   Thanks in advance

  Thanks---Ep
• • Reply
  

  Caddre

  All-Star

  26581 Points

  5308 Posts

  Re: Re:Re: About the membership provider

  Dec 14, 2006 03:16 AM|LINK

  epimentel

  Thank you very much.

   I'm new to the forum and also to Visual Studio .NET.  It may be obvious, but I got the code and I don't know how to make VS see the new provider.

   Thanks in advance

  You asked for the code and I have given it to, how to use it is covered below.  Hope this helps.

  http://weblogs.asp.net/scottgu/archive/2006/04/13/442772.aspx

  Kind regards,
  Gift Peddie
• • Reply
  

  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>
• • Reply
  

  epimentel

  0 Points

  9 Posts

  Re: Re:Re: About the membership provider

  Dec 14, 2006 09:54 PM|LINK

   

  I'm having problems installing ODP.NET for Oracle 10gR2.  I'm running Windows 2000, and I'm able to connect to the database using SQL Plus without any problems.  I downloaded ODP.NET for Oracle 10gR2, ran setup.ext, it creaded a new home, and when I go to the folders there are no files.

  Any suggestions? 

  Thanks.

  Thanks---Ep
• • Reply
  

  epimentel

  0 Points

  9 Posts

  Re: Re:Re: About the membership provider

  Dec 14, 2006 09:57 PM|LINK

   

  I'm having problems installing ODP.NET for Oracle 10gR2.  I'm running Windows 2000, and I'm able to connect to the database using SQL Plus without any problems.  I downloaded ODP.NET for Oracle 10gR2, ran setup.ext, it creaded a new home, and when I go to the folders there are no files.

  Any suggestions? 

  Thanks.

  Thanks---Ep
• • Reply
  

  Caddre

  All-Star

  26581 Points

  5308 Posts

  Re: Re:Re: About the membership provider

  Dec 15, 2006 02:02 AM|LINK

  I am not sure if you can install 10g in Win2k pro but I have installed it in Win2k Advanced server with 4gig of ram, I know you will need at least 1gig of ram.  Hope this helps.
  Kind regards,
  Gift Peddie
• • Reply
  

  mlasell

  Member

  467 Points

  173 Posts

  Re: Re:Re: About the membership provider

  Dec 15, 2006 09:01 PM|LINK

   I did the install on my hard drive, and then had to do it again on the webserver. I had to get the network admin to do the install on the webserver since I don't have permissions

    On my hard drive a second Oracle client was created. In it is the folder and file odp.net/bin/1.x/Oracle.DataAccess.dll. I had to add that reference to the website and put the dll in a Bin flder at the root of the website.

  I could send it to you if thats what you are looking for.

  Michael

• • Reply
  

  epimentel

  0 Points

  9 Posts

  Re: Re:Re: About the membership provider

  Dec 15, 2006 11:50 PM|LINK

   

  I guess I have it working now.  I added the reference to the website, the Oracle.DataAccess.dll file.  I created a connectionString using one of the components, I tested a query and it works.  When I run the website though, it gives me this error:

  System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.

  Thanks Michael and Gift.

  Thanks---Ep
• • Reply
  

  Caddre

  All-Star

  26581 Points

  5308 Posts

  Re: Re:Re: About the membership provider

  Dec 16, 2006 12:04 AM|LINK

  It is a known bug try the link below to fix it.  Hope this helps.

  http://dotnetjunkies.com/WebLog/rtgurskevik/archive/2005/01/19/45958.aspx

  Kind regards,
  Gift Peddie