Go to Google Groups Home    microsoft.public.dotnet.framework.aspnet
Re: ASP.Net Membership & Roles Using MySQL- Basics Needed.

Cowboy (Gregory A. Beamer) <nospammgbwo...@comcast.netnospamm>

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" <danofwea...@googlemail.com> wrote in message

news:76228ffb-c313-4d0c-93dd-ef2e418ae627@q24g2000prf.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/08/mysql-aspnet-membership-and-ro...
> 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/database/mysqlmembershipprovider.aspx?f...
> 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/2007/12/12/UsingMySQLWithAspnetForA...
> 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