MySQL Connection Help

From: Robb Kerr (rkerr_at_digitaliguana.com)
Date: 11/16/03 

To: php-general@lists.php.net
Date: Sun, 16 Nov 2003 10:09:48 -0600

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 = tempftp@quinnserver.com
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 = tempftp@quinnserver.com
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

Relevant Pages

  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Complicated Connection Problems bewteen ADP and SQL Server
    ... This database ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... might be in my ADO connection string. ...
    (microsoft.public.access.adp.sqlserver)
  • Complicated Connection Problem between ADP and SQL Server
    ... This database ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... might be in my ADO connection string. ...
    (microsoft.public.sqlserver.connect)
  • Re: ADO Connection Timeout
    ... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... When the first test is run, the results are stored in the central database. ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)