I'm using Connector/NET to connect to MySQL from ASP.NET 2.0. But the problem is my hosting server only support ODBC connector and I don't want to use it.
Is there any solution, such as importing the driver to the application or anything else?

I don't think so. In order for Conector/NET to be available it would have to be installed on the server for you to use it under ADO.NET 2.0.