Filed under: Mysql | Tags: Hosting ASP.NET Mysql project, Unable to find the requested .Net Framework Data Provider, Unable to find the requested .Net Framework Data Provider. It may not be installed.
I have faced very complex problem when i am using Mysql Datasource in SQLDatasource. It give reference error like “Unable to find the requested .Net Framework Data Provider” in the time of hosting the site in remote server where Mysql Data connector is not install. After spending long time in the web, i get the solution of this problem. This give me relax at last.
Cause: I have used SQLDatasource to populated a grid to retrieve data from the internet. here i select mysql as data source.
Here is SQLDatasource Setting,
Here is my connection String
This configuration work well in local machine. But when i upload this site for hosting in remote server, this encounter an error which says that the mysql provider name is not found.
Solution:
I have added some extra configuration in my web.config file.
Again it is noted that all above change is applicable only to the application “web.config” file in the host server. If host server already installs mysql data connector, then there is no change required. I am using Mysql Data Connector Version 5.1. For Upper version i will be required some minor change in the Control assembly ID number.
Here i give the snap shoot and download link of “web.config” file of my well working site,
Please make comment if this post do any help to you.
Thanks
Khayer
GIS Programmer, CEGIS
Bangladesh
References:
http://forums.asp.net/p/1253461/2323702.aspx
http://forums.mysql.com/read.php?38,145720,145760#msg-145760
17 Comments so far
Leave a comment
Thanks, It worked. It’s really helpful. Keep it up!
Comment by Raj August 20, 2008 @ 3:53 pmVery usefull, I was searching a solution for at least 3 hours now. You save my day in 30 seconds.
Comment by Paulo Melo September 13, 2008 @ 4:38 amThanks.
Thank you so much! This worked out perfectly! For those using IXWebHosting, remember to go to Account Settings > Dedicated Application Pool and set up your domain there too.
Best!!
Comment by Mr Bluesummers February 16, 2009 @ 2:59 amDear Khayer
Greetings from England and thank you very much for posting your solution. On my host web.config I have only added the tag so far, it worked without adding the tags at this stage. It may be that they are already included in a “global” setting somewhere.
Comment by Dr Phil May 9, 2009 @ 11:55 amDear Khayer
I should not have used angle braces in my last post! It should have read “On my host web.config I have only added the [DbProviderFactories] tag so far, it worked without adding the [add namespace] tags at this stage. It may be that they are already included in a “global” setting somewhere.” Sorry about that.
Comment by Dr Phil May 9, 2009 @ 11:58 amhi,
Comment by Oğuz Yılmaz August 18, 2009 @ 7:23 pmfirst, thanks to you for your help, but my application couldn’t work on the local machine, my problem related with local, i carry out your methodology but i get an error like this:
System.ArgumentException: Unable to find the requested .Net Framework Data Provider. It may not be installed.
Please help me!
Install Latest version of mysql data connector in your local machine.
Comment by khayer August 20, 2009 @ 8:46 amThanks, helped me a lot.
Comment by James D December 16, 2009 @ 1:14 amthis is my web.config
<!–
The section enables configuration
of the security authentication mode used by
ASP.NET to identify an incoming user.
–>
<!–
The section enables configuration
of what to do if/when an unhandled error occurs
during the execution of a request. Specifically,
it enables developers to configure html error pages
to be displayed in place of a error stack trace.
–>
here after executing this i am getting an error
Required attribute ‘invariant’ not found.
what i have to do?
please any one suggest me
Comment by santhosh December 17, 2009 @ 5:50 pmThis worked perfectly. Thank you very much for this information!
Comment by Ardee Aram February 3, 2010 @ 1:23 amthanks dude it really help me a lot….
Comment by Hemant March 10, 2010 @ 11:43 pmhello sir,
Comment by Naim Khan February 3, 2011 @ 2:34 pmsame problem i m getting in windows Application… not in Web Application so please tell me how can solve my problem in C#…..
hello sir,
Comment by Naim Khan February 3, 2011 @ 2:35 pmSame problem i m getting in Windows Application not in Web Application so i you have any idea how can solve it then please reply me ASAP…
@Naim Khan
Comment by khayer February 28, 2011 @ 12:04 pmIn window version this problem should not been happen. So please check your connection setting carefully and try used updated driver from MySql data.
Thanks thanks and many many thanks….
You have solved my problem. Keep up the good work.
Thanks once again.
Comment by Jehanzeb March 16, 2011 @ 6:08 pmVery usefull post. It worked
Comment by Aubin Dadjo March 26, 2011 @ 4:29 pmThank you so much!
Thanks alot, It worked for me. It’s really helpful
Comment by Aladin October 13, 2011 @ 11:49 pm