connecting web pages to a database

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.

"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.

> 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] ?
>

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] ?

"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.

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

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#707105992

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

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 ?

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/

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] ?