[Desperate] ASP + MySQL

[simon_wks]

Please...Please...

I have been banging my head against the wall. I spent endless time doing online research but still fruitless. I hope that you may help me.

1. I know how to develop a site on my local machine using ASP and MySQL. I installed IIS and MySQL on my machine. I have a virtual directory C:\site_name and directory for MySQL which is C:\MySQL. The 'Data' directory of MySQL is C:\MySQL\Data.

2. Once completed (in the future), I will host the site on using free hosting service. This bothers me so much. Should my ASP codes be altered significantly to do so?

3. How should I access to MySQL database? I know how to use MyODBC. Where should I relocate the 'Data' directory for MySQL? Should I still use 'root' as the user?

I AM SO DESPERATE... PLEASE HELP ME... ANY ONLINE REFERENCE?

I REALLY NEED TO DO THIS... My FINAL YEAR ENGINEERING PROJECT DEPENDS ON THIS ONE... PLEASE

Regards,
Simon

[mjz]

well, i know virtually no asp but this seems to mostly be a mysql question...

whatever host you go with will have the info you need, most hosts have a faq section and if the answer you're looking for isn't there an email should solve the problem... :)

a good idea though is to have one document that connects to the database, and include it on all pages... that way you only have to change username and password and dbname in one place when you upload your site to the new host.