asp & mysql

[omerbutt]

hi there i have been working with asp and Access Database before and now i would like to switch to mysql database i have searched diffeent forums and could not deide which one good to use with asp and how to use it means the installation procedure and the way how to connect to it
can anyone guide me in this respect i have been working in php with mysql also so i just had a glimps in my mind if i could continue using mysql ith asp also.
regards,
Omer Aslam

[DrBunchman]

Hi Omer,

MySQL will work fine with ASP - the basic SQL syntax is the same as you probably know from using it with PHP. MySQL is a good choice because it's free!

You'll need to change your connection strings to use the MySQL driver rather than the Access provider e.g.

 DRIVER={MySQL ODBC 3.51 Driver}; 

Hope this helps,

Dr B

[omerbutt]

Hi Omer,

MySQL will work fine with ASP - the basic SQL syntax is the same as you probably know from using it with PHP. MySQL is a good choice because it's free!

You'll need to change your connection strings to use the MySQL driver rather than the Access provider e.g.

 DRIVER={MySQL ODBC 3.51 Driver}; 

Hope this helps,

Dr B

okay,
but tell me Dr B hat i have already installed phpmysql on my pc with xamp server now do i have to seperately install another copy of mysql to configure it with asp or can i reuse the previous installation
thanks for any help in advance ,
Regards,
Omer Aslam

[DrBunchman]

No, MySQL is a separate entity from PHP - you should be able to connect to your existing databases without changing your database set up.

Give it a go and let me know how you get on.

Dr B