Hi,
I have written a script in asp and the database it supports is Microsoft MS SQL
Now If I change the sql files to mysql
will the asp code still work without problem or should I still need to make some changes?
can I still have stored procedure in mysql?
should I just change the connection?
any example or reference will be greate help

You cant just change database servers and have your script work correctly, you wil have to have the MySQL driver installed on your server and will have to rework your connection string.

If you are using any relase of MySQL prior to version 5.0, no, you can not have Views/Stored Procedures.

Your connection string should look something similar to this:

"driver={MySQL ODBC 3.51 Driver};server=myserver;uid=myUserID;pwd=mypasswor d;database=myDatabase;option=16387;port=3306;"

hth.

--Stole this from a moderator

I will only tell you how to do it, not do it for you.
Unless, of course, you want to hire me to do work for you.