No Testing server error

erickia · erickia

I am a student trying to learn Dreamweaver MX 2004. I'm trying to setup a PHP
page and connect to a MySQL Database. MySQL is running and using the default
directories. I can access the database and tables using Navicat so I know they
are working. I went through the steps of setting the site and document type
and then tried to setup the testing server. I chose a name, used "localhost"
as the url, put in the user and password and then tried to select the Database.
When I click the select button, it tries to load but then comes back with an
error saying "There is no Testing Server running on the server machine. What
am I doing wrong?

David Powers · David Powers

erickia wrote:

> When I click the select button, it tries to load but then comes back with an
> error saying "There is no Testing Server running on the server machine. What
> am I doing wrong?

The first thing you are doing wrong is not checking the forum archives.
This must be the most frequently asked question.

Have you set up a PHP site in site definitions?
Have you set the URL Prefix correctly in Testing Server? It must have a
trailing slash on the end, for example [url]http://localhost/myphpsite/[/url]
Have you checked that MySQL is enabled in your version of PHP? It's not
enabled by default in PHP 5

There are several other possibilities, but those are the most frequent
causes of failure.

--
David Powers
Author, "Foundation PHP 5 for Flash" (friends of ED)
Co-author "PHP Web Development with DW MX 2004" (Apress)
[url]http://computerbookshelf.com[/url]

gareth · gareth

Have you actually set up a testing server in your site definition? You need
to have a web server running, either on your own PC, or on your web hosts
server to allow Dreamweaver MX to connect to the MySQL database.

Take a look at my MySQL connection guide at:

[url]http://www.dreamweavermxsupport.com/index.php?type=article&pid=60&sid=61[/url]

Explains how the connection works and give troubleshooting information to
help get the connection working.

--
Gareth - TMM Dreamweaver
[url]http://www.dreamweavermxsupport.com/[/url]
[url]http://www.garethdp.com/[/url]

PHP Login Suite V2 - 34 Server Behaviors to build a complete Login system.
[url]http://www.phploginsuite.co.uk/[/url]

Co-Author: Dreamweaver MX: Instant Troubleshooter - Apress
Co-Author: Practical Intranet Development - Apress
Co-Author: Dreamweaver MX: Advanced PHP Web Development - Apress
Co-Author: Dreamweaver MX: PHP Web Development - Wrox

erickia · erickia

First of all, I did try the archives and didn't find anything that helped.
MySQL is enabled in PHP5. When I place the following code in a file titled
today.php and then place the address [url]http://localhost/today.php[/url] in the address
bar, the date is displayed and the Success message is displayedl.

Code:

<!DOCTYPE html PUBLIC "-/W3C/DIT XHTML 1.0 Strict/EN"
"http://www.w3.org//TR/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Today's Date</title>
<meta http-equiv="content-type"
content="text/html; charset=iso-8859-1" />
</head>
<body>
<p>Today's Date (according to the Web server) is
<?php

echo date('1, F ds Y.');

?></p>
<?php
if (@mysql_connect("localhost", "root", "########"))
echo "Successfully Connected to Database";
else
echo "ERROR Connecting to Database";
?>
</body>
</html>

The site info points to a folder under the user's documents folder. The MySQL
server location is set to 'http://localhost/" and the user and password are
the same as in the above code. What next?

David Powers · David Powers

erickia wrote:

> The site info points to a folder under the user's documents folder. The MySQL
> server location is set to 'http://localhost/" and the user and password are
> the same as in the above code. What next?

Is the user's documents folder inside the web server document root? All
PHP pages must be in the server root, a virtual host, or a virtual
directory.

The correct address for MySQL is "localhost", *not* "http://localhost".

--
David Powers
Author, "Foundation PHP 5 for Flash" (friends of ED)
Co-author "PHP Web Development with DW MX 2004" (Apress)
[url]http://computerbookshelf.com[/url]

erickia · erickia

Thanks David. That did the trick. I hope that it is OK that I pass that site on?

David Powers · David Powers

erickia wrote:

> Thanks David. That did the trick. I hope that it is OK that I pass that site on?

Which site? If you're referring to my installation instructions at
[url]http://computerbookshelf.com/phpdw/install1.php[/url], please do.

--
David Powers
Author, "Foundation PHP 5 for Flash" (friends of ED)
Co-author "PHP Web Development with DW MX 2004" (Apress)
[url]http://computerbookshelf.com[/url]

No Testing server error

Thread Tools

Display

No Testing server error

Similar Questions and Discussions

Testing Server problem: Server name or address couldnot be resolved!

Testing Server

Using Server Behaviors without Testing Server

testing server.?

Testing Server Error

Re: No Testing server error

Re: No Testing server error

Re: No Testing server error

Re: No Testing server error

Re: No Testing server error

Re: No Testing server error

Posting Permissions