Dreamweaver MYSQL Connection

Report · Dec 22, 2006

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.

My hosts advise the following:

Please note you are on a Linux server that doesn't support ODBC

They suggest that i switch to a windows server and advise that this is not as secure and that not all PHP functions are suuported, which is no good to m
e.

Does anybody know how to connect Dreamweaver to my existing server?

Report · Dec 22, 2006

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/

Report · Dec 22, 2006

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.

Report · Dec 22, 2006

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/

Report · Dec 22, 2006

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.

Report · Dec 22, 2006

Hi Gareth,

That has sorted it, thank you very much.

If possible could i contact you directly to ask a few questions about php login suite before i download it?

Report · Dec 22, 2006

Sure, thats fine. Email me at: support@phploginsuite.co.uk with you`re
questions and i`ll do my best to answer them.

Cheers

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