Upgrading MySQL Connector/Net
- by Todd Grover
I am trying to publish a website with our hosting provider. I am getting error due to the fact that they only allow a medium trust and the MySQL Connector/Net that I am using requires reflection to work. Unfortunately, reflection is not allowed in a medium trust.
After some research I found out that the newest version of the MySQL Connector/Net may solve this problem. Connector/Net 6.6 includes enhancements to partial trust support to allow hosting services to deploy applications without installing the Connector/Net library in the GAC. I am thinking that will solve my problem.
So, I unistalled MySQL Connector/Net 6.4.4 and I installed MySQL Connector/Net 6.6.4.
When I run the application in Visual Studio 2010 I get the error:
ProviderIncompatibleException was unhandled by user code
The message is
An error occurred while getting provider information from the database. This can be caused by Entity Framework using an incorrect connection string. Check the inner exceptions for details and ensure that the connection string is correct.
InnerException is
The provider did not return a ProviderManifestToken string.
Everything works fine when I have Connector/Net 6.4.4 installed. I can access the database and perform Read/Write/Delete action against it.
I have a reference to the following in the project:
MySql.Data
MySql.Data.Entity
MySql.Web
My connection string in Web.config
<connectionStrings>
<add name="AESSmartEntities"
connectionString="server=ec2-xxx-xx-xxx-xx.compute-1.amazonaws.com;
user=root;
database=nunya;
port=3306;
password=xxxxxxx;"
providerName="MySql.Data.MySqlClient" />
</connectionStrings>
What might I be doing wrong? Do I need any additional setting(s) to work with version 6.6.4 that wasn't required in the older version 6.4.4?
