ASP.Net Membership & Roles Using MySQL- Basics Needed. - microsoft.public.dotnet.framework.aspnet

Message from discussion ASP.Net Membership & Roles Using MySQL- Basics Needed.
From: "sloan" <sl...@ipass.net>
References: <76228ffb-c313-4d0c-93dd-ef2e418ae627@q24g2000prf.googlegroups.com> <#yzt##1mIHA.3512@TK2MSFTNGP03.phx.gbl> <b0b6c960-2039-4685-a2b4-47a90ec759d1@24g2000hsh.googlegroups.com> <00e73621-bc2e-444e-ac19-31a5390e9af3@z24g2000prf.googlegroups.com>
Subject: Re: ASP.Net Membership & Roles Using MySQL- Basics Needed.
Date: Fri, 11 Apr 2008 10:35:26 -0400
Lines: 70
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
Message-ID: <#UI9hD#mIHA.5368@TK2MSFTNGP04.phx.gbl>
Newsgroups: microsoft.public.dotnet.framework.aspnet
NNTP-Posting-Host: 64.246.215.5
Path: g2news1.google.com!news2.google.com!newshub.sdsu.edu!msrtrans!TK2MSFTFEEDS02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP04.phx.gbl


C) Change the ASP.NET Web Site Administration Tool to 'know' that
we're now using a remote provider...


I believe the WSAT tool is only available locally.....I learnt this the hard 
way.
Thus my opinion is that is is a hobbyist tool, and not worth the effort.


You probably don't want to hear this, but I'll give you the advice anyways.

Go here:
http://aspnet.4guysfromrolla.com/demos/printPage.aspx?path=/articles/010307-1.aspx



And take a hour or so ... and get the crappy Access Membership Provider 
working.
Try not to just look at the code setup/config setup, but actually get it 
working.

You'll learn the key items needed to swap out to a custom one.

..

Then approach the MySql version with that knowledge.
Once you get one working..the others seem easier.
I suggest the Access one becaue at least you have one that differs 
signficantly from Sql Server...but is decently documented.

..

I did this (a year and half ago) and that little exercise still sits with 
me....as I can swap out to a custom one quickly now.



This might help as well.
http://www.devx.com/asp/Article/29256/0/page/3





"DanWeaver" <danofwea...@googlemail.com> wrote in message 
news:00e73621-bc2e-444e-ac19-31a5390e9af3@z24g2000prf.googlegroups.com...
> Later still and...
>
> I believe a few steps are necessary and Im not sure of the order or
> exactly how to go about them:
>
> A) Create the DB schema on a (shared host) MySQL db... Does anybody
> have the SQL already made?
>
> B) Set up the asp project to have a reference to the correct provider
> ie do something in web.config relating to <providers> and <connection
> string>...
>
> C) Change the ASP.NET Web Site Administration Tool to 'know' that
> we're now using a remote provider...
>
> D) Any other mystical steps involving importing namespaces etc...
>
> Any takers?
>
>
>