Problem deploying MySQL app

Question

I am putting together a small proof-of-concept app in LightSwitch 2011 running against a MySQL database which is hosted remotely.  In debug mode on my development machine the program can quite happily view and access the data from MySQL but as soon as I deploy the app to a web server I am getting red crosses and "Unable to load data" messages...

Using Fiddler I can see that the actual error being returned is as follows:
Schema specified is not valid. Errors:
mc4trialData.ssdl(2,271) : error 0175: The specified store provider cannot be found in the configuration, or is not valid.

There is presumably nothing fundamentally wrong with the database or the local copy of the application wouldn't be able to access the data so I can only assume that there is some aspect of the configuration which is being lost when I package and deploy the app.  If anyone can shed any light on what I am doing wrong I would be most grateful.

Paul

Answer 1

You need to install the MySQL .Net driver in your deployment server.

---

"HARD WORK BEATS TALENT WHEN TALENT DOESN'T WORK HARD"

HAROLD GLENN MINERVA
http://hgminerva.wordpress.com

If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. This will help other users to find their answer quickly.

Answer 2

Yes, that is installed.  The server has 5.2.5 and my development machine has 6.4.5 but I don't see anything in the connection string that is version specific - would this make a difference?

Answer 3

Hi Paul,

I also cannot target which is error. I've searched this issue on web and found that the version of provider is important.

I suggest you to try the version above 6.3.

Answer 4

Thanks for the suggestion, I don't have full control of the server but I'll see if I can persuade them to upgrade the driver to a later version.  I'll let you know what I find.