connecting web pages to a database

Report · Sep 04, 2007

I have a book about "PHP WEB DEVELOPMENT WITH DREAMWEAVER MX 2004" Well I followed instructions to "connecting web pages to a database" but when I press "test" in the "MySQL Connection dialog box" a message that can not connect appears "An unidentified error has occurred." , well ?

Report · Sep 04, 2007

Could be any one of about 500 reasons..........

Without more information it is impossible for anyone here to offer accurate
advice. The best you will get is a stab in the dark.

"123polis123" <webforumsuser@macromedia.com> wrote in message
news:fbji6f$6sf$1@forums.macromedia.com...
>I have a book about "PHP WEB DEVELOPMENT WITH DREAMWEAVER MX 2004" Well I
> followed instructions to "connecting web pages to a database" but when I
> press
> "test" in the "MySQL Connection dialog box" a message that can not connect
> appears "An unidentified error has occurred." , well ?
>

Report · Sep 04, 2007

"MySQL Connection dialog box" has a field "Connection name", where I define/find this to phpMyAdmin ? As "MySQL Server" what to insert , localhost what means ?

Report · Sep 04, 2007

The connection name is just a name you make up to describe this connection.
The connection itself would be to the database server, NOT to PHPMyAdmin -
usually by IP address. You must also enter a database name/user/password.

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.dreamweavermx-templates.com - Template Triage!
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
==================

"123polis123" <webforumsuser@macromedia.com> wrote in message
news:fbk0lb$mjk$1@forums.macromedia.com...
> "MySQL Connection dialog box" has a field "Connection name", where I
> define/find this to phpMyAdmin ? As "MySQL Server" what to insert ,
> localhost what means ?

Report · Sep 05, 2007

Where/how I find this "Connection name" ? As "MySQL Server" what to insert , insert: "localhost", what means ? Where/how I find this "MySQL Server" ?

Report · Sep 05, 2007

123polis123 wrote:
> Where/how I find this "Connection name" ?

Connection name is whatever you want to call it. A lot of people use
conn followed by the name of the website. For example: connMySite.

>As "MySQL Server" what to insert , insert: "localhost", what means ? Where/how I find this "MySQL Server" ?

The value of MySQL Server is the server address. In 95% of all cases,
it's localhost, which simply means that MySQL is on the same computer as
the webserver. If MySQL is on a different server, you need to get the
server address from your hosting company.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

Report · Sep 05, 2007

"Connection name" given from dreamweaver or from....? In which point exactly(dialogbox) in given ?

Report · Sep 05, 2007

123polis123 wrote:
> "Connection name" given from dreamweaver or from....? In which point exactly(dialogbox) in given ?

It's the name that YOU decide to give the connection, so that you can
select the correct connection when using Dreamweaver server behaviors.

Before you can use Dreamweaver server behaviors, you need to define a
MySQL Connection.

The instructions for creating the MySQL Connection are on pages 157-159
of the book that you're using. Figure 5-1 shows the Connection name as
Apress. You can use anything you like: myConnection, uncleGeorge,
sweetheart... It doesn't matter what you choose. It's YOUR decision.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

Report · Sep 05, 2007

In the "MySQL Connection dialog box" to NOT get a message that can not connect [appears "An unidentified error has occurred." ] I must be connected from DMWR MX 2004 directly to the web server [edit pages on server when saved to my hdd] ?

Report · Sep 05, 2007

123polis123 wrote:
> "An unidentified error has occurred."

Because it's an unidentified error, it's difficult to say what the
problem might be. However, the most likely causes are these:

1. You have not defined the testing server correctly in your site
definition.

2. A firewall or other software is preventing communication between
Dreamweaver and MySQL.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

Report · Sep 06, 2007

I fix testing server, it goes to connect but a new message appear , this time:
"2002 Can't connect to local MySQL server through socket '/usr/local/mysql-5.0/data/mysql.sock' (2)" , well ?

Report · Sep 06, 2007

123polis123 wrote:
> I fix testing server, it goes to connect but a new message appear , this time:
> "2002 Can't connect to local MySQL server through socket '/usr/local/mysql-5.0/data/mysql.sock' (2)" , well ?

Are you using a Mac? The first thing to try is to restart your computer.
Each time you restart, the computer creates a new version of mysql.sock,
which Mac and Linux computers use to connect to MySQL. It's possible
that it's just in the wrong place.

If that doesn't help, try the instructions in this post on the friends
of ED forum:

http://friendsofed.infopop.net/4/OpenTopic?a=tpc&s=989094322&f=5283032876&m=886105992&r=707105992#70...

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

Report · Sep 06, 2007

I use godaddy hosting Linux/PHP (WebServer).
My laptop is winXP(dmwr mx 2004).

Report · Sep 06, 2007

"123polis123" <webforumsuser@macromedia.com> wrote in message
news:fbope0$8pp$1@forums.macromedia.com...
>I use godaddy hosting Linux/PHP (WebServer).

that may be the problem right there. GD is not known to be the most friendly
of hosts when it comes to database-driven sites.

Report · Sep 15, 2007

godaddy hosting says: Please note that we do not allow external connections to our database servers.
this mean I can not use dmwr mx2004 server behaviors / connection tools / records sets ?
What the server must be to do this ? I must contact provider [or I may find this to server hosting characteristics] ?

Report · Sep 15, 2007

> this mean I can not use dmwr mx2004 server behaviors / connection tools /
> records sets ?

No. It means that you must have a local database to develop with, rather
than using the remote server.

If you are using ASP/Accesss, you can do this with IIS as your local
webserver, and an ODBC connection to the database. If you are using MySQL,
I think you need Apache as your local webserver.

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.dreamweavermx-templates.com - Template Triage!
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
==================

"123polis123" <webforumsuser@macromedia.com> wrote in message
news:fcg473$2pl$1@forums.macromedia.com...
> godaddy hosting says: Please note that we do not allow external
> connections to
> our database servers.
> this mean I can not use dmwr mx2004 server behaviors / connection tools /
> records sets ?
> What the server must be to do this ? I must contact provider [or I may
> find
> this to server hosting characteristics] ?
>

Report · Sep 15, 2007

"Murray *ACE*" <forums@HAHAgreat-web-sights.com> wrote in message
news:fcggap$evc$1@forums.macromedia.com...
...
> If you are using MySQL, I think you need Apache as your local webserver.

Nope that's not true, database drivers are not part of a webserver, these
are completely separate programs.

Report · Sep 15, 2007

Yeah - thanks, I was a little muddled there only because I've only ever used
MySQL with PHP.

--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.dreamweavermx-templates.com - Template Triage!
http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs, Tutorials & Resources
http://www.macromedia.com/support/search/ - Macromedia (MM) Technotes
==================

"Joris van Lier" <whizzrd@hotmail.com> wrote in message
news:fcggi6$f5m$1@forums.macromedia.com...
> "Murray *ACE*" <forums@HAHAgreat-web-sights.com> wrote in message
> news:fcggap$evc$1@forums.macromedia.com...
> ...
>> If you are using MySQL, I think you need Apache as your local webserver.
>
> Nope that's not true, database drivers are not part of a webserver, these
> are completely separate programs.