I'm trying to connect to MySQL db from Dreamweaver and after 2 days, I'm starting to loose my pacient.
Macromedia blames PHP for any "unexplain" reason why their software might not connect to MySQL.
I tried everything they said on their support page and still no result.
Anyone in here uses Dreamweaver to write PHP with a mySQL backend?
Something I found is that php.ini when installed in Windows comments the include_path lines, lines that supposely, Dreamweaver needs to access MySQL when using PHP to connect.
The error message I get from Dreamweaver when I leave the comments on the include_path lines in the php.ini file is:
"Undefined Error"
and when I remove the comments I get:
"Error parsing C:\WINDOWS\php.ini on line 435" which is the line that had the comments.
Help! anyone that have successfully connected to MySQL with via Dreamweaver.
I have upgrade my Mysql to 5 Beta, and php to 5 also trying to see if that would fix the problem but with no result.
Many thanks,
Jay - Florida
Hi,
I've been using Dreamweaver 2004MX to write PHP/mySql database web apps for about a year now without problem.
Did you use the .msi file to install PHP or did you install and configure it manually? I found that the .msi method leaves a lot out - modules in particular if you are using Apache - very annoying.
I'm a bit perplexed why Dreamweaver blames PHP. When you set up a mySql connection in Dreamweaver it's just a plain tcp connection. If you set the mySql database permissions up correctly for the account you are using for the connection it should just do its thing and display the schema. The only times I found that it did not were when:
1. The local mySql client was too old to authenticate on the version of mySql it was connecting to (bad one when we updated to mySql 4.1xx from 4.0xx)
2. The mySql server was set up to reject network connections.
3. The firewall on the mySql server did not allow the port mySql was using (3306 usually)
Are you using PHP for web apps or local scripts?
Cheers,
Jennifer - Australia
