Bug #67824 The provider did not return a ProviderManifestToken string.
Submitted: 6 Dec 2012 9:51 Modified: 27 May 2013 16:20
Reporter: Tirumalesh Tamarana Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / NET Severity:S2 (Serious)
Version:6.4.3.0 OS:Windows (not creating database in codefirst.)
Assigned to: Fernando Gonzalez.Sanchez CPU Architecture:Any
Tags: asp.net, codefirst, myqsl, mysql connector net 6.4.3.0

[6 Dec 2012 9:51] Tirumalesh Tamarana
Description:
i'm using entity framework 4.1 code first model without existing database with my sql provider 6.4.3.0 in asp.net mvc 4. I'm experiencing that the error: 'The provider did not return a ProviderManifestToken string.' and innerexception Unknown database 'sampledbcontext'. if i tried with my sql connector net 6.4.4.0 it creating well, so i there any work around to solve this problem. And the solution may not be upgrading to newer version, because i'm using this in server, so if i upgrade so many application will not work.

Stack Trace:

[MySqlException (0x80004005): Unknown database 'sampledbcontext']
   MySql.Data.MySqlClient.MySqlStream.ReadPacket() +251
   MySql.Data.MySqlClient.NativeDriver.AuthenticateNew(Boolean reset) +438
   MySql.Data.MySqlClient.NativeDriver.Authenticate(Boolean reset) +139
   MySql.Data.MySqlClient.NativeDriver.Open() +2436
   MySql.Data.MySqlClient.Driver.Open() +70
   MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) +250
   MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection() +39
   MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() +372
   MySql.Data.MySqlClient.MySqlPool.TryToGetDriver() +198
   MySql.Data.MySqlClient.MySqlPool.GetConnection() +125
   MySql.Data.MySqlClient.MySqlConnection.Open() +764
   MySql.Data.MySqlClient.MySqlProviderServices.GetDbProviderManifestToken(DbConnection connection) +73
   System.Data.Common.DbProviderServices.GetProviderManifestToken(DbConnection connection) +34

[ProviderIncompatibleException: The provider did not return a ProviderManifestToken string.]
   System.Data.Common.DbProviderServices.GetProviderManifestToken(DbConnection connection) +163
   System.Data.Entity.ModelConfiguration.Utilities.DbConnectionExtensions.GetProviderInfo(DbConnection connection, DbProviderManifest& providerManifest) +35
   System.Data.Entity.DbModelBuilder.Build(DbConnection providerConnection) +159
   System.Data.Entity.Internal.LazyInternalContext.CreateModel(LazyInternalContext internalContext) +50
   System.Data.Entity.Internal.RetryLazy`2.GetValue(TInput input) +117
   System.Data.Entity.Internal.LazyInternalContext.InitializeContext() +423
   System.Data.Entity.Internal.LazyInternalContext.MarkDatabaseInitialized() +16
   System.Data.Entity.Database.Initialize(Boolean force) +23
   SampleMySql.SampleDbContext..ctor() in D:\Projects\Work\SampleMySql\SampleMySql\SampleDbContext.cs:14
   SampleMySql._Default.Page_Load(Object sender, EventArgs e) in D:\Projects\Work\SampleMySql\SampleMySql\Default.aspx.cs:14
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
   System.Web.UI.Control.OnLoad(EventArgs e) +91
   System.Web.UI.Control.LoadRecursive() +74
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2207

How to repeat:
if i change the version to 6.4.3.0 it resolving, need to find my sql connector net 6.4.3.0 supported for code first entity framework?
[23 Jan 2013 19:03] Fernando Gonzalez.Sanchez
Have you tried latest versions of Connector/NET (either 6.6.4 (recommended) or 6.5.5 or 6.4.5)?

There was a known issue on the past when the manifest token was dependent on regional settings (worked well for English, bad for others).
[24 Feb 2013 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[25 Feb 2013 11:42] Tirumalesh Tamarana
Yeah, i upgraded to the latest mysql connector and problem solved.

Thanks,
Tirumalesh.