ASP.Net Membership & Roles Using MySQL- Basics Needed.

[DanWeaver]

I am trying to use a MySQL db hosted on a shared server as an ASP.NET
Membership Provider and .net framework 3.5 (visual studio 2008)
I am new to a lot of this and have found the following websites which
offer some degree of help but by no means a complete solution or
uncomplicated explanation of whats involved:

1) http://blog.nolanbailey.com/2008/03/...e-provider/194
Very good but not complete enough for my level eg:
"<add name="MySQLMembershipProvider" autogenerateschema="true" ...."

2)
http://aspnet101.com/aspnet101/tutorials.aspx?id=63
Looks initially promising and the kind of solution simplicity I would
expect in reality but...
the first stage of the proceeedings doesnt work out for me on my vista
machine....
c:\Windows\Microsoft.NET\Framework>aspnet_regsql -W
'aspnet_regsql' is not recognized as an internal or external command,
operable program or batch file.

3)
http://www.codeproject.com/KB/databa...select=2476367
Many credible sources point to this page but running MySQL
Administrator and trying to execute the sql to alter tables I run into
syntax errors the origins of which I dont yet understand.

4) http://www.dotnetsurfers.com/Blog/20...orization.aspx
Not sufficiently detailed.

Can anyone point me to a reasonable set of instructions to SETUP ASP
MEMBERSHIP AND ROLES ON A MySQL db on a SHARED REMOTE SERVER, USING
Visual Studio 2008 and its Login, New Member etc wizards and
templates?

I would really appreciate any help.

Dan - posted also to comp.MySQL

[Cowboy \(Gregory A. Beamer\)]

I would look up Custom Membership Provider. You will have to create one to
use MySQL instead of a supported database.

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

Subscribe to my blog
http://gregorybeamer.spaces.live.com/lists/feed.rss

or just read it:
http://gregorybeamer.spaces.live.com/

*************************************************
| Think outside the box!
|
*************************************************
"DanWeaver" <da*********@googlemail.comwrote in message
news:76**********************************@q24g2000 prf.googlegroups.com...

>I am trying to use a MySQL db hosted on a shared server as an ASP.NET
Membership Provider and .net framework 3.5 (visual studio 2008)
I am new to a lot of this and have found the following websites which
offer some degree of help but by no means a complete solution or
uncomplicated explanation of whats involved:

1)
http://blog.nolanbailey.com/2008/03/...e-provider/194
Very good but not complete enough for my level eg:
"<add name="MySQLMembershipProvider" autogenerateschema="true" ...."

2)
http://aspnet101.com/aspnet101/tutorials.aspx?id=63
Looks initially promising and the kind of solution simplicity I would
expect in reality but...
the first stage of the proceeedings doesnt work out for me on my vista
machine....
c:\Windows\Microsoft.NET\Framework>aspnet_regsql -W
'aspnet_regsql' is not recognized as an internal or external command,
operable program or batch file.

3)
http://www.codeproject.com/KB/databa...select=2476367
Many credible sources point to this page but running MySQL
Administrator and trying to execute the sql to alter tables I run into
syntax errors the origins of which I dont yet understand.

4)
http://www.dotnetsurfers.com/Blog/20...orization.aspx
Not sufficiently detailed.

Can anyone point me to a reasonable set of instructions to SETUP ASP
MEMBERSHIP AND ROLES ON A MySQL db on a SHARED REMOTE SERVER, USING
Visual Studio 2008 and its Login, New Member etc wizards and
templates?

I would really appreciate any help.

Dan - posted also to comp.MySQL

[DanWeaver]

Thanks very much Greg and Sloane,

Greg- the KB code project looks worth a shot- the MySQLcode is like
French to me!

Sloane- thanks for the sage and frank advice, Ill have a good look at
the 4guys.

Cheers,
Dan