mysql and c# winform app problem

Hi all,
I use MySqlMembershipProvider and MySqlRoleProvider from Codeproject for my project. Before this I created a test project:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Web;
using System.Web.Security;
using System.Configuration.Provider;
using System.Collections.Specialized;
using System.Data;
using System.Collections;
using System.Configuration;
using System.Diagnostics;
using System.Globalization;
using System.Security.Cryptography;
using System.Web.Configuration;
using System.Reflection;
using System.Text.RegularExpressions;
using MySql.Data.MySqlClient;
namespace vusers
{
class Program
{
static void Main(string[] args)
{
mmi.MySqlMembershipProvider m = new mmi.MySqlMembershipProvider();
MembershipCreateStatus status = default(MembershipCreateStatus);

m.CreateUser("aa", "aaaaaa1!", [email protected], "beast", "Roni", true, null, out status);
Console.WriteLine(status.ToString());
if (m.ValidateUser("aa", "aaaaaa1!"))
Console.WriteLine("You are authorized!");
else{
Console.WriteLine("Not such user!");
Console.ReadLine();
}

}
}
}
My app.confog is:
xml version="1.0" encoding="utf-8" ?>

<configuration>

<connectionStrings>
<remove name="ConnString"/>
<add name="ConnString" connectionString="Database=sof_mmi;Data Source=localhost; User Id=mmi;Password=qwe123; providerName=MySql.Data.MySqlClient"/>
connectionStrings>

<system.data>
<roleManager enabled="true" defaultProvider="MySQLRoleProvider">
<providers>
<add connectionStringName="ConnString" applicationName="Balkantel" name="MySQLRoleProvider" type="MySql.Web.Security.MySQLRoleProvider, Version=6.0.4.0, Culture=neutral, PublicKeyToken=C5687FC88969C44D"/>
providers>
roleManager>
<membership defaultProvider="MySQLMembershipProvider">
<providers>
<add name="MySQLMembershipProvider" type="MySql.Web.Security.MySQLMembershipProvider, MySql.Web, Version=6.0.4.0, Culture=neutral, PublicKeyToken=C5687FC88969C44D" connectionStringName="LocalMySqlServer" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="false" applicationName="/" requiresUniqueEmail="false" passwordFormat="Clear" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="3" minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10" passwordStrengthRegularExpression="" autogenerateschema="true"/>
providers>
membership>
<profile defaultProvider="MySQLProfileProvider">
<providers>
<add name="MySQLProfileProvider" type="MySql.Web.Profile.MySQLProfileProvider, MySql.Web,Version=6.0.4.0, Culture=neutral, PublicKeyToken=C5687FC88969C44D" connectionStringName="ConnString" applicationName="/" />
providers>
profile>
system.data>

configuration>
the problem is that I recieve:
ProviderError
Not such user!
Could you, please tell me where am I wrong with my code?
Thanks and regards,
Trifon.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Trifon Dinev17y ago
I've solved my problem, the problem now is connected with Guid. I recieve error in cast, if you use Scot's tutorials about membership and roles. Any suggestion? The only change is that I use MySQL instead of MS SQL.

Thanks in advance.

Trifon.

Andrzej17y ago

 <add name="ConnString" connectionString="Database=sof_mmi;Data Source=localhost; User Id=mmi;Password=qwe123; providerName=MySql.Data.MySqlClient"/>

connectionStrings>

  
I think your application allows access only for user Id=nmi and you are logging as a different user.
---
Andrzej Krynski
http://akrynski.republika.pl