SQL connection question

Hi guys, so far i'm only using MS Access database, and i'm also using the following connection:



my question is, if i decide to move to MySQL, can i still use the same connection as above, and if not what should be changed?

also does the Access database need to be converted to MySQL database and how can i do that ?

Finally i'm using 7host.com to host the asp files and the database, how can i upload the MySQL database and access it from the asp files?

also would the code in the asp files change if the database is changed, like( SQL commands) ?

thx in adv..

1. Each driver has it's own connection string format. For more info on connection strings visit ConnectionStrings

2. To convert your access db to mysql, well, can't do that, they are two different products, For one, you'll have to create the MySQL db using command line or if your host provides for MySQLAdmin utility, you can create it like MSSQL Enterprise Mgr.
Then you'll have to import your data, I believe you can import a csv into MySQL

3. You're going to have to find out if your host supports MySQL and ASP.
Without this, I'm afraid that you simply cannot do parts 1 and 2.

HTH