Ok, I feel like a complete bonehead because I can't seem to figure this
thing out. But, I readily welcome someone making me feel worse by pointing
out my simple mistake. I can't get DW to connect to a MySQL database on a
new server with which I'm working. I've worked with other servers and
haven't had a problem. I'm providing all of the connection and password
information so that you can help me - don't worry, I'll change all these
once I've solved the problem. BTW, I've also posted this in the Dreamweaver
newsgroups but they're not as helpful as this one, so please excuse the
fact that this is a ways off-topic.

Site URL = http://quinnserver.com
FTP URL = ftp.quinnserver.com
FTP Username = [EMAIL PROTECTED]
FTP Password = password
MySQL database = quinn_tempdb
MySQL table = addresses
MySQL Username = quinn_tempdbuser
MySQL Password = password

myPhpAdmin provides the following connection script which works...

<?php $dbh=mysql_connect ("localhost", "quinn_tempdbuser", "password") or
die ('I cannot connect to the database because: ' . mysql_error());
        mysql_select_db ("quinn_tempdb");
?>

I have built a page which works fine when uploaded to the server...
http://quinnserver.com/dbcheck.php

Here's my question... What do I enter in DW's Testing Server and MySQL
Connection dialogues to be able to use the database and table during the
development phase without having to upload the pages to the server?

Please confirm the following settings and tell me where I'm wrong or fill
in what I've left out.

In the Testing Server area of DW's Site Definition dialogue...
Server Model = PHP MySQL
Access = FTP
FTP Host = ftp.quinnserver.com
Host Directory = 
Login = [EMAIL PROTECTED]
Password = password

In the MySQL Connection dialogue...
Connection Name = QuinnServer
MySQL Server = 
User Name = quinn_tempdbuser
Password = password
Database = quinn_tempdb

I apologize for the "newbieness" of this question but it's been driving me
crazy and I'm sure I'm just missing something simple. Thanx in advance for
any help provided.
-- 
Robb Kerr
Digital IGUANA
Helping Digital Artists Achieve their Dreams
http://www.digitaliguana.com
http://www.cancerreallysucks.org

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to