Hi guys, here is the problem: In my project, I connect to the database in my hosting domain successfully, project run perfectly locally, and when I tried to deploy it to my hosting website. 1, validate connection in publish setting said "the remote server connection succeeded, but webmatrix cannot access databases. 2, publish compatibility showed database not available, 3, after deploying, the error"unable to find requested .net framework data provider" appeared. I don't know why database connection is fine only in local running, and can't connect to it during deployment. Btw, my connection string is fine as well. As a beginner, I believe this is a common error someone may face, I don't know is it because win host doesn't support mysql deployment or not. Please give me some advice, many thanks!!
I found this web page article regarding the .net framework data provider error message you're getting here: http://stackoverflow.com/questions/...framework-data-provider-it-may-not-be-install It might be that you need to bin deploy all of the correct dll files your project is using on the hosted web server. I don't know if you really mean a MySQL database or a MS SQL database. If you're talking about a MS SQL database and you need to learn how to deploy it onto our hosted SQL database. Read our knowledge base article here: https://support.Winhost.com/kb/a1049/how-to-transfer-your-local-sql-database-to-Winhost.aspx If you need to restore a MySQL database. You can use the MySQL Workbench's Import and Backup feature. Read our knowledge base article on how to connect to your MySQL database using MySQL Workbench here: https://support.Winhost.com/kb/a832/connect-to-mysql-with-mysql-workbench.aspx
