Message from discussion
ASP.Net Membership & Roles Using MySQL- Basics Needed.
From: "Cowboy \(Gregory A. Beamer\)" <NoSpamMgbwo...@comcast.netNoSpamM>
References: <76228ffb-c313-4d0c-93dd-ef2e418ae627@q24g2000prf.googlegroups.com>
Subject: Re: ASP.Net Membership & Roles Using MySQL- Basics Needed.
Date: Thu, 10 Apr 2008 18:08:10 -0500
Lines: 60
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: <#yzt##1mIHA.3512@TK2MSFTNGP03.phx.gbl>
Newsgroups: microsoft.public.dotnet.framework.aspnet
NNTP-Posting-Host: c-98-193-193-3.hsd1.tn.comcast.net 98.193.193.3
Path: g2news1.google.com!news1.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!t-online.de!TK2MSFTFEEDS02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP03.phx.gbl
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-role-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/database/mysqlmembershipprovider.aspx?fid=234396&df=90&mpp=25&noise=3&sort=Position&view=Quick&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/2007/12/12/UsingMySQLWithAspnetForAuthenticationauthorization.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