I'm a novice when it comes to mysql, I mainly worked on MS SQL. I created this site with a MS SQL database but now I need to change it to a mysql database. I'm creating the website on local machine running XP Pro with IIS and DW MX.
I downloaded mysql v 4.0.2, mysql control centre and mysql Administrator. Using the control centre I created the database and you can see all tables etc. Created a password for root. In dreamweaver I saved my index.asp page as index.php and then edited the site details. On Advanced remote info: local/network and specified remote folder in IIS. On testing page I set it up as Server model - php MySQL, Access - local and URL Prefix - localhost. I also copied the 'mmhttppdb.php file into the mm_ serverscripts folder in case of corruption.
When I try to connect to database using the following:
Connection Name - xyz
MySql Server - localhost
Username - root
Password - xyz
and when I click test I get the following error
'HTTP Error Code 405 Method not allowed'.
I have looked at other forums with the same problem and I think I've done everything right. As I say I'm new to mysql but I would like to learn so any help will be greatly appreciated. Thanks

Go to your admin tools
Start/Settings/Control Panel/ Admin Tools/ Internet Information Services

Expand directory structure from your local computer (what every you named it) to Web Sites to Default Web sites.

Right click and check the properties.
Under Documents add default.php

Under Home Directory look down in the Applications Settings area.
Click on Configuration
ADD browse to your php.exe file then add .php as the extension.

If the directory is not php enabled the MySQL script can not run and you get the 405 error. Hope this helps. Leesa

Also, if you are new to MySQL you might want to look into NAVCAT from PremiumSoft. Interacts with MySQL just like MS Access. Much easier than hand coding everything.

Thanks for the help it's all connecting now, so I've amended most of the pages to mysql but I've noticed that you lose some of the options in' server behaviours' like: log in user,log out user, go to detail page and total records display etc, do I have to hand code these in or is there another way of doing it?
Thanks once again

Hi,
I had to upgrade to DWMX2004 to get the user authorization behaviors for PHP MySQL. Well worth it.

For form validation I just found the extension from yaromat.com Had major problems with the VDaemon from X-Code working with DWMX2004. Hopefully the Yaromat one will work much better. The one that comes built in with DW is to basic for most uses. Good luck!! Leesa

Hi, I thought about that after I posted the last reply and I've set about getting DMW2004 so lets see. Will let you know