Hi,
I've read this problrm in some form, but there was never given answer to them

When I am trying to connect a MySql database with dreamweaver MX.
Connection a database I get error messages like
1)'cannot put MMHTTPDB.PHP'
2) 'cannot put mysql.php
3) sometimes even 504 method not allowed

I've read the technote of micromedia on this at:
www.macromedia.com/support/dreamweaver/releasenotes/mx/releasenotes_mx.html#php
but that wasnt conclusive.

Now the strange part,
Bypassing al these error I've managed to get a connectionfile, showing tables in the bindingstab.
Somehow I can only create manual(advanced mode) queries. In simple mode no columns are shown.

Anyone an idea about this?



cheers
Patrick

It is likely you are getting these errors (including the 504, method not allowed) for one of 2 reasons:-

1) You have not correctly defined your website within Dreamweaver MX. You need to ensure that you have entered values for Local, Remote AND testing server, and that these values are correct.

If you are using FTP as the transfer method you must ensure that your username and password combination are correct, and that the path to your web root folder is correct. If you have to change to another folder (like htdocs, for example) you MUST include this in the path, otherwise you will find that you can't upload any files.

If you're connecting over a LAN then you do not have read/write permissions to the location you have specified.

The reason that you don't get any columns etc showing is because these two files (MMHTTPDB.PHP and mysql.php) are internal files, used by DMX to communicate to your database server. Without them things just won't work.

Tim Green

Extension & PHP TalkZone Manager
<font size=1>-------------------------------------------
<i>Please read the Forum FAQ before posting
a question to this TalkZone.</i>
-------------------------------------------
www.UDzone.com : A dynamic Dreamweaver,
Ultradev and Fireworks site for developers
by developers.
-------------------------------------------</font id=size1>

In am working on a win98 machine so all permission should be ok.

Also the connections are ok. I've tried a dozen combinations, since neither one ever worked.

I am starting to wonder, do I need to have specific settings defined in the php.ini file perhaps? (i am using php4.2)

Hi, Ive had this problem too. Ive jus started using PHP and MySQL, and in DW MX i am having the same problems. Also when i go to add a recordset sometimes it will connect to the database without any problems. But it just wont see the tables.. it says **no tables found. But there is a table in the database? Anyone able to help me with that?

Thanks

Rusoul

Does DWMX support PHPversion4.2 or higher?

Hello DMX Zone,

Recently I purchased a server at ServerPronto.com and I have been experiencing connecting Dreamweaver to the database itself. I have been through almost every tutorial on the internet it seems like, but still I cannot list the tables or the live data. I set the server to allow for DNS lookups and have used my login and password to connect view the available databases successfully in the connection scripts window; however, when I go to make a record set, no tables are listed in the database drop-down window.. I was hoping that you may have some answers to aid me in this dilema I am experiencing. Also, I dont know if this would help but I am using Mysql and Php on a Linux box.



Thank you,



John P