ASP & MySQL
--------------------------------------------------------------------------------
I hear and see alot of webhosting companies offering ASP & MySQL and I would like to know if I convert my Access to MySQL do I still use the same commands and command structure I use now for updating records, creating records, deleting records, creating tables, paging database results and etc.? I ask because I need to know what, if any, changes I need to make to my pages before I consider this switch.
If not could you please direct me to where I can learn what commands I can use to do those things in VBScript.
Thank You
-------------------------------------------------------------------------------
If your SQL kept along the lines of ANSI - SQL your database code changes should be minimal. As far as converting from ASP to PHP in my opinion you have more flexibility and functionality as well as a wider audience.
...
If you need specific help let us know.
I have mysql on linux box. How do i import access database to mysql. What are the commands for it. Do they not have mysql as user interface reather then command base??
Can this mysql work with asp? just like sql 2000 dose with asp?