ASP.NET Application with MySQL on IIS

Question

I want to run an ASP.Net app on an ISS-Server (Windows Server 2008).

I have installed the "MySQL-Connector" and the MySQL-DB. I published the ASP.Net app and copied the result into the wwwroot folder.

When i try to run the app, the following errormessage shows up:

Unable to find the requested .Net Framework Data Provider.  It may not be installed. 
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.ArgumentException: Unable to find the requested .Net Framework Data Provider.  It may not be installed.

Source Error: 

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.  

Stack Trace: 


[ArgumentException: Unable to find the requested .Net Framework Data Provider.  It may not be installed.]
   System.Data.Common.DbProviderFactories.GetFactory(String providerInvariantName) +1402071
   System.Data.EntityClient.EntityConnection.GetFactory(String providerString) +34

I can't fiqure out why this error is thrown, because i definitely installed the connector. Should I add something in the Web.Config or somewhere else?

From the WEB.Config: <add name="DBContext" connectionString="metadata=res://*/MySQL.csdl|res://*/MySQL.ssdl|res://*/MySQL.msl;provider=MySql.Data.MySqlClient;provider connection string="server=localhost;User Id=*****;database=*****;password=*****"" providerName="System.Data.EntityClient" /> — Sunnygurke
– Sunnygurke, Commented Jan 24, 2013 at 11:20

Lloyd · Accepted Answer · 2013-01-24 11:30:05Z

2

Does your published build contain the connector? Check the bin folder.

Most likely your connector installed to the GAC on the development machine and it is not copied locally to the project, so when you do a build it just builds the site and assumes you've installed it on the server too.

You can manually force it to copy the connector locally by selecting the reference in the Solution Explorer, right clicking and choosing Properties and set Copy Local to true.

answered Jan 24, 2013 at 11:30

Lloyd

29.7k5 gold badges89 silver badges100 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Sunnygurke Over a year ago

Why should there be a connector in the folder? I installed this one: mysql.de/products/connector It worked for the developement machine, so i installed it on the server too. EDIT: The connector i use was a simple msi file.

Lloyd Over a year ago

There shouldn't if it's in the GAC of both machines.

Sunnygurke Over a year ago

Well... I just reinstalled the Connector on the server... and it works.. Thanks for all your help!!

Collectives™ on Stack Overflow

ASP.NET Application with MySQL on IIS

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related