4

I have:

  • MVC 3
  • MySQL using .NET Connector 6.4.4

Everything is ok if i connect from local PC with VS2010 to remote DB on Linux. I made a backup to have DB locally and install the same version of MySQL (5.5, x64)

On remote i have normal .net autogenerated table names for membership, like my_aspnet_membership, but when i start applicantion locally it create other table names, like mysql_membership. Also i got the exception: Unable to initialize provider. Missing or incorrect schema.

With same settings, but with connection to Remote DB everything works fine. 

<add name="MySqlSessionStateProvider" type="MySql.Web.SessionState.MySqlSessionStateStore, MySql.Web, Version=6.4.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" applicationName="/" autogenerateschema="true" connectionStringName="MySqlMembershipConnection" />

Does anybody know where is the problem?

Erik Philips
  • 53,428
  • 11
  • 128
  • 150
Evgeniy Labunskiy
  • 2,012
  • 3
  • 27
  • 45
  • I'm not familiar with the .NET Connector 6.4.4 but does the " autogenerateschema="true" "generate your SQL schema on the fly? –  Jun 03 '12 at 07:44
  • Can you connect to the database and read the tables using the same connection string from a unit test or simple console app? – Eric J. Jun 08 '12 at 04:46