specify membership tables - MySQL DotConnect

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
create_software
Posts: 1
Joined: Sat 18 Apr 2015 09:28

specify membership tables - MySQL DotConnect

Post by create_software » Sat 18 Apr 2015 09:34

Hi

I get this error

[MySqlException (0x80004005): Table 'protoDB.aspnet_users' doesn't exist]
Devart.Data.MySql.bi.a() +290
Devart.Data.MySql.bi.i() +217
Devart.Data.MySql.af.a(ab[]& A_0, Int32& A_1, Boolean A_2) +134
Devart.Data.MySql.af.a(Byte[] A_0, Int32 A_1, Boolean A_2, String A_3) +148
Devart.Data.MySql.h.e() +199
Devart.Data.MySql.h.m() +89
Devart.Data.MySql.MySqlCommand.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords) +2016
Devart.Common.DbCommandBase.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords, Boolean nonQuery) +53
Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery) +838
Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior) +43
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() +12
Devart.Common.Web.Providers.DbRoleProvider.a(String A_0, String A_1, String A_2, String A_3) +769

[ProviderException: An exception occurred. Please contact your administrator.]
Devart.Common.Web.Providers.DbRoleProvider.a(String A_0, String A_1, String A_2, String A_3) +1017
Devart.Common.Web.Providers.DbRoleProvider.GetRolesForUser(String username) +172
System.Web.Security.RolePrincipal.IsInRole(String role) +9625187
System.Web.Configuration.AuthorizationRule.IsTheUserInAnyRole(StringCollection roles, IPrincipal principal) +98
System.Web.Configuration.AuthorizationRule.IsUserAllowed(IPrincipal user, String verb) +167
System.Web.Configuration.AuthorizationRuleCollection.IsUserAllowed(IPrincipal user, String verb) +190
System.Web.Security.UrlAuthorizationModule.OnEnter(Object source, EventArgs eventArgs) +9727941
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +136
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +69
I have configured my Dot connect MySql connector as the role,membership and profile provider and i have the appropriate tables already .

I know why it's looking for an ASPNET_users table but i need it to look for that information in another table.

How can i specify the tables it should look in ?

Thanks

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: specify membership tables - MySQL DotConnect

Post by Pinturiccio » Tue 21 Apr 2015 14:52

create_software wrote:I know why it's looking for an ASPNET_users table but i need it to look for that information in another table.
APS.NET provider table names are used internally in the provider, and you cannot change them. If you want to use a custom table, you need to implement your own Membership provider. For more information, please refer to https://msdn.microsoft.com/en-us/librar ... 40%29.aspx

Post Reply