problems: asp files, from access to mysql
I run a site which is written in asp. I used access database but now i have upgraded to mysql. With asp and mysql my site runs smoothly.
From this momment i began to have serious problems.
I am testing and looking for good asp scrips almost everyday.
Untill now that i had my site run with access mdb, i had no problem because all i had to do is copy the tables of the script's mdb to my main mdb database, change the paths, and that's all!
Now, i found all these excellent scripts and i have to tell that all of them come with an access database.
This is exactly my problem.
Now, cannot run these scripts properly. I import tables through odbc import with an easy-to-use graphic mysql database manager, but then the script no longer works.
It seems that there is problem either with the asp code which needs changes(what changes?) or mysql incompatibility.
What really happens?
Is it asp matter? Or mysql problem?
It is not my potention to use php, althought mysql is almost identical for this. Because i use asp do i have to use either access or ms sql? But i 've heard that mysql and asp can be a good pair with no problems.
So please tell me what i should do in order to be able to use every script that comes with access database, with a mysql database.
Thanks in advance