connecting to the MySQL database on the server

[pkeene]

I use Dreamweaver CS3. I'm trying to connect to the database on a hosting server. I had done this in the past, but on a different comptuer. When I get to the mySQL connection window and I enter the informaiton I get this errror:

HTTP Error Code 404 File Not Found. Here are some possible reasons for the problem:

1) There is no testing server running on the server machine.
2) The testing server specified for this site does not map to the http://207.45.187.42/_mmServerScripts/MMHTTPDB.asp URL. Verify that the URL Prefix maps to the root of the site.

The hosting site says this is the correct path http://207.45.187.42/~denise/_mmServerScripts/MMHTTPDB.php, but I get the same error from it.

When I set up the testing server I left the host field blank, but have tried /public_html/ which is the host directiory for the rest of the site. I get the same error as above.

One thread in the forum suggested that you had to install MySQL in the IIS directory. My new computer does not have the version of Vist to do this.

Lost and confused.

[Guest]

I'm having the same issue. hope someone can help.

[Newsgroup_User]

What platform are you on? asp or php. You refer to both.

[pkeene · Accepted solution]

It took awhile but I finally figured it out. Under site definitions/testing server in the url prefix I had to put the ip address of the website as well as the root folder. I had to ask the hosting server what that was since it was different than what they told me to use to up load my documents. In my case it was the ip adddress/~denise.

After that everything worked fine.