I really can't get a connection between my website and the MySQL database on it. For developing I use VS2008. Now, how to create the data connection? Which data provider I need to use?
I have MySQL also installed locally, and use the MySQL . NET data provider. That works fine. But online this connection won't work due to the following error:
Unable to find the requested . Net Framework Data Provider. It may not be installed.
So I think I need another data provider, but which one? In VS2008 I don't see another appropriate for MySQL.
Does anybody know how to deal with it?