Message from discussion
ASP.Net Membership & Roles Using MySQL- Basics Needed.
Path: g2news1.google.com!postnews.google.com!q24g2000prf.googlegroups.com!not-for-mail
From: DanWeaver <danofwea...@googlemail.com>
Newsgroups: microsoft.public.dotnet.framework.aspnet
Subject: ASP.Net Membership & Roles Using MySQL- Basics Needed.
Date: Thu, 10 Apr 2008 15:58:53 -0700 (PDT)
Organization: http://groups.google.com
Lines: 37
Message-ID: <76228ffb-c313-4d0c-93dd-ef2e418ae627@q24g2000prf.googlegroups.com>
NNTP-Posting-Host: 87.112.77.81
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1207868334 19059 127.0.0.1 (10 Apr 2008 22:58:54 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 10 Apr 2008 22:58:54 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: q24g2000prf.googlegroups.com; posting-host=87.112.77.81;
posting-account=8FHYRAgAAAAAK1kaS8vQDx4G7nZHgtTC
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-GB; rv:1.8.1.13)
Gecko/20080311 Firefox/2.0.0.13,gzip(gfe),gzip(gfe)
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
|
