Dreamweaver MYSQL Connection

I think its probably the URL prefix thats causing problems, you have:

url prefix: http://ftp.sliplandgalleries.com/htdocs/

htdocs is an internal path and shouldn't be in the url, as the web root maps
to htdocs anyway. This means when Dreamweaver uploads its files to
communicate with the database it thinks there in
www.sliplandgalleries.com/htdocs/mmServerScripts when they would actually be
in www.sliplandgalleries/mmServerScripts

Change the URL prefix to:

http://www.sliplandgalleries.com/

and it should work.

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

Site is defined as PHP MYSQL

Database connection as follows:

MYSQL Server: mysql2.streamline.net
Username: my username
Password: my password
Database: my database

testing server

Server model:php mysql
Access:ftp
FTP host:ftp.sliplandgalleries.com
host directory:/htdocs
login: mylogin
password: my password
url prefix: http://ftp.sliplandgalleries.com/htdocs/

How are you connecting to the database? Have you defined a database
connection in Dreamweaver MX, where you enter the host name as "localhost"
if the MySQL server is on the same physical server as the web server, and
your MySQL user name and password.

The inbuilt connection in Dreamweaver MX doesn't use ODBC, it connects
directly to the MySQL server through PHP, so I don't know why you are
getting there errors. Have you defined your site as PHP?

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

DarrenSHughes wrote:
> I am attempting to create PHP pages in Dreamweaver MX and connect to MYSQL.
> The database exists on my server and i get the following error when testing
> the connection in Dreamweaver
>
> A server timeout has occured. here are the possible reasons.
> 1. Please make sure that the web server is up and running.
> 2. Please verify that the ODBC DSN exists on the testing server.

It's a very long time since I used Dreamweaver MX, but the method of
connection hasn't changed. I presume that you want to use your remote
server as the testing server. What settings have you used for the
Testing Server in your Site Definition?

--
David Powers, Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/