Can I switch from MS Access to MySQL with Asp?

[KevinCO]

Hi, first I would like you for taking the time to read my post. I was given a job working on a commerical web site that was mostly finished, but the owner of the company stopped dealing with the Web Designer company for many reasons, so Its my job now to make the site better. It uses ASP with a MS Access DB. The Access DB is painfully slow. The only other DB the web host offers is MySql, which I want to use for performance reasons. Currently, I have a separate file, 'data.asp', that sets the Access DB connection(ADODB Connection, the Connection String, etc..) that is included in every ASP that uses the DB(<!--Include File=&quot;data.asp&quot;-->). My question is, can I change the 'data.asp' to a MySql DB Connection(after I set up and populate the MySql DB) and not have to change anything with all the other Asp's that use the 'data.asp'?

 

[KarveR]

Can't see any reason why not but you'd probably get the clearest poicture asking this in the Microsoft Access, ASP or PHP forum where its (probably) been tried before. ***************************************
Party on, dudes!

 

[mikebarnetson]

ASP can connect to MySQL databses through ODBC. The ODBC driver for MySQL is downloadable from mysql.com You will require less resource and get better performance with MySQL over Access. Also take a look at MyCC which is a useful MySQL admin tool (also at mysql.com).