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'?

 

[link9]

That all depends on whether or not the previous developer used ANSI standard SQL when they developed the site.

If they did, then you should have no trouble. If not, then the troubles should not be too widespread. You'll just have to go through and test everything in the site, squashing bugs where you find them.

For instance, Access takes dates with #'s surrounding them, whereas MySQL (if I'm not mistaken), takes dates with 's around them, much like SQL Server.

Wish I could give you a better answer than &quot;it depends&quot;, but I'm afraid it's the correct answer.

good luck!
paul