I created a website and mySQL database which work fine on my computer but when I upload it to my hosting company I get an error message “Unable to find the requested .Net Framework Data Provider”
My hosting company (Premium Reseller) hasn’t been much use, as they tried telling me that while they are a recommended hosting company for Webmatrix by Microsoft, that they “Do not support asp.net & mysql combination. Mysql database go with PHP.”
This doesn’t make sense to me, since I would expect that I should be able to use Razor as instructed in the WebMatrix tutorials to connect to my database.
Does anyone know a workaround or do I need to rebuild my connections in php?
I don't know which provider you are using for MySQL, but you should include the dll for that. Your connection string in your web.config should contain a reference to a specific provider for MySQL. MySql.Data.dll, perhaps?
I must confess, I know little or nothing about MySQL. However, it surprises me that they say they cannot offer any support, yet presumably, they must offer MySQL as a database server otherwise you cannot get your database installed on their servers?
This definitely seems strange to me too and I know there must be a solution :-( They've been really unhelpful and rude, but since I'm on a deadline I'd rather not have to find another provider right now and try to get this working.
The hosting company (Premium Reseller) supports asp.net and mySQL, although I had difficulty publishing the database through WebMatrix and therefore had to upload it through phpMyAdmin.
I've included their Server in the connection string in my web.config, but the only .dll file files I have are the ones I listed :-( Is there somethng else I should be including?
Your hosting provider should fix this for you. Presumably they know you are using MySQL, so they need to make sure that the appropriate provider is installed on the server, to they should tell you which MySQL provider they support if its not the one you
are currently using.
Regards
Jeremy
If this has helped Please: Don't forget to click "Mark as Answer" on the post that helped you.
That way future readers will know which post solved your issue.
ChayaCooper
Member
121 Points
65 Posts
Getting an error message “Unable to find the requested .Net Framework Data Provider”
Jan 01, 2012 07:11 PM|LINK
I created a website and mySQL database which work fine on my computer but when I upload it to my hosting company I get an error message “Unable to find the requested .Net Framework Data Provider”
My hosting company (Premium Reseller) hasn’t been much use, as they tried telling me that while they are a recommended hosting company for Webmatrix by Microsoft, that they “Do not support asp.net & mysql combination. Mysql database go with PHP.”
This doesn’t make sense to me, since I would expect that I should be able to use Razor as instructed in the WebMatrix tutorials to connect to my database.
Does anyone know a workaround or do I need to rebuild my connections in php?
Mikesdotnett...
All-Star
154852 Points
19855 Posts
Moderator
MVP
Re: Getting an error message “Unable to find the requested .Net Framework Data Provider”
Jan 01, 2012 08:50 PM|LINK
Add the relevant dll to your bin folder and try again.
Beginning ASP.NET Web Pages with WebMatrix | My Site | Twitter
ChayaCooper
Member
121 Points
65 Posts
Re: Getting an error message “Unable to find the requested .Net Framework Data Provider”
Jan 01, 2012 09:58 PM|LINK
I uploaded all the .dll files that were in my bin Folder (as listed below). Is there something else I need to add?
System.Web.WebPages.Deployment.dll
WebMatrix.WebData.dll
System.Web.Helpers.dll
System.Web.Razor.dll
System.Web.WebPages.Administration.dll
System.Web.WebPages.dll
System.Web.WebPages.Razor.dll
WebMatrix.Data.dll
WebMatrix.Security.dll
NuGet.Core.dll
Microsoft.Web.Infrastructure.dll
Mikesdotnett...
All-Star
154852 Points
19855 Posts
Moderator
MVP
Re: Getting an error message “Unable to find the requested .Net Framework Data Provider”
Jan 01, 2012 10:41 PM|LINK
I don't know which provider you are using for MySQL, but you should include the dll for that. Your connection string in your web.config should contain a reference to a specific provider for MySQL. MySql.Data.dll, perhaps?
I must confess, I know little or nothing about MySQL. However, it surprises me that they say they cannot offer any support, yet presumably, they must offer MySQL as a database server otherwise you cannot get your database installed on their servers?
Beginning ASP.NET Web Pages with WebMatrix | My Site | Twitter
ChayaCooper
Member
121 Points
65 Posts
Re: Getting an error message “Unable to find the requested .Net Framework Data Provider”
Jan 02, 2012 06:39 PM|LINK
This definitely seems strange to me too and I know there must be a solution :-( They've been really unhelpful and rude, but since I'm on a deadline I'd rather not have to find another provider right now and try to get this working.
The hosting company (Premium Reseller) supports asp.net and mySQL, although I had difficulty publishing the database through WebMatrix and therefore had to upload it through phpMyAdmin.
I've included their Server in the connection string in my web.config, but the only .dll file files I have are the ones I listed :-( Is there somethng else I should be including?
Mikesdotnett...
All-Star
154852 Points
19855 Posts
Moderator
MVP
Re: Getting an error message “Unable to find the requested .Net Framework Data Provider”
Jan 02, 2012 07:42 PM|LINK
Your hosting provider should fix this for you. Presumably they know you are using MySQL, so they need to make sure that the appropriate provider is installed on the server, to they should tell you which MySQL provider they support if its not the one you are currently using.
Beginning ASP.NET Web Pages with WebMatrix | My Site | Twitter
jeremyh
Star
8173 Points
1477 Posts
Re: Getting an error message “Unable to find the requested .Net Framework Data Provider”
Jan 02, 2012 07:48 PM|LINK
You will need to add the Mysql connector dll to the bin folder - MySql.Data.MySqlClient
Some good steps are at http://dturnerblog.blogspot.com/2010/08/using-mysql-with-webmatrix.html
And you can get the file from Nuget @ http://nuget.org/packages/MySql.Data
Jeremy
If this has helped Please: Don't forget to click "Mark as Answer" on the post that helped you.
That way future readers will know which post solved your issue.
ali.alakhdar
Member
168 Points
83 Posts
Re: Getting an error message “Unable to find the requested .Net Framework Data Provider”
Jan 02, 2012 08:07 PM|LINK
right click your database ane see properties ... there you ahould find the provider
good luck
ChayaCooper
Member
121 Points
65 Posts
Re: Getting an error message “Unable to find the requested .Net Framework Data Provider”
Jan 02, 2012 08:32 PM|LINK
I've included the info it listed in the properties below, but I'm not sure who the provider is. Would that be phpMyAdmin?
General: index.php?db=c2f_demo_dec2011&token=3148f44c3f3e8b32a8f83b1694efc1de
Protocol: HyperText Transfer Protocol
Type: PHP File
Address(URL): http://184.154.153.51/phpmyadmin/index.php?db=c2f_demo_dec2011&token=3148f44c3f3e8b32a8f83b1694efc1de
ChayaCooper
Member
121 Points
65 Posts
Re: Getting an error message “Unable to find the requested .Net Framework Data Provider”
Jan 02, 2012 08:56 PM|LINK
I just added the MySql.Data.MySqlClient dll to the bin folder (and uploaded it to my site) but it's still not working :-( Any suggestions?