Skip to main content
A
Anonymous
July 26, 2006
Answered

DreamweaverMX and a MySQL database

  • July 26, 2006
  • 3 replies
  • 1166 views
Hi

I am trying to connect to my MySQL database in DreamwaeverMX.

When I try to add the MySQL Connection I put data as follow.

Connection Name :connTrio
Server Name : localhost
User Name : root
Password : password

I get message error "unidentifed error has occurred" When I try to select database.

I can confirm that the database is present, mysql is running, password used is correct.

Hope someone can help

Best Regards,

Martin
This topic has been closed for replies.
Correct answer
Hi
The "nightmare" is over !!!
Found this Wamp Server Set up

http://www.wampserver.com/en/download.php

100% working in less than 10 mins!

3 replies

N
Newsgroup_User
Inspiring
July 28, 2006
Dax Trader wrote:
> Here are instructions I followed
> http://www.tanguay.at/installPhp5.php5?step=1

Those instructions use the deprecated method of installing PHP, which
has not been recommended for at least two years. However, I see you have
solved your problem by installing WAMP.

The fact that you now have a working installation is good news.
Everything may work fine; and in one sense that's what really matters.
Unfortunately, you have followed a poor set of instructions, which may
have left files lurking on your system that could cause future
incompatibilities.

A lot of people like WAMP and XAMPP, and both have good reputations; but
none of the all-in-one installers are approved by PHP:

http://uk2.php.net/manual/en/install.windows.php

Anyway, since you have a working installation, I think it's best to
leave well enough alone. You can now concentrate on working with dynamic
pages. Good luck.

--
David Powers
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "Foundation PHP 5 for Flash" (friends of ED)
http://foundationphp.com/
A
Anonymous
July 27, 2006
Hi David
Sorry got confused over the binaries, of course I did not use that for PHP

Here are instructions I followed
http://www.tanguay.at/installPhp5.php5?step=1

Maybe if you have a look at the above link you will see where / IF it has given wrong advice.

Notice that some of the replies on that link mentioned both windows and system 32.

Dont give up on me please :-))
I really think you are my only hope on this.

Martin
A
Anonymous
Correct answer
July 27, 2006
Hi
The "nightmare" is over !!!
Found this Wamp Server Set up

http://www.wampserver.com/en/download.php

100% working in less than 10 mins!

N
Newsgroup_User
Inspiring
July 26, 2006
Dax Trader wrote:
> I get message error "unidentifed error has occurred" When I try to select
> database.

This is probably one of the most frequently asked questions here.
Because the error is unidentified, you need provide the following
information for anyone to give you much help:

Which version of Dreamweaver?
What operating system?
Which version of PHP?
Which version of MySQL?
Does your version of PHP have MySQLI enabled?

--
David Powers
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "Foundation PHP 5 for Flash" (friends of ED)
http://foundationphp.com/
A
Anonymous
July 26, 2006
Hi
You said
Which version of Dreamweaver?
Reply 7.1
What operating system?
Reply Win XP
Which version of PHP?
Reply 5
Which version of MySQL?
Latest download
Does your version of PHP have MySQLI enabled?
I did at one point have PHP5 installed and Apache 2
I tested the server and all OK
I tested mysql and all ok
I tested (the install page) on PHP and all ok.

I ran a test live data (simple page) from within dreamweaver and it delivered back the server time so PHP was working.
So....individually all seems ok.

It seems like I have not integrated PHP with the server (god knows I have tried) I have followed every different instruction I could find on the internet to achieve this without success.
I ASSUME that it is this that is causing the failure of me to conect to the mysql database?

I have spent more than 36 hours to try to get set up so I can develop php and test on my local machine, I cant see that this is or should be that difficult. BUT I note in your response that it is the most asked question?
Tis very worrying that Macromedia must know this and yet dont seem to offer a definitive answer.

I will be delighted, estactic, and eternally in you debt if you can help me sort this. :-))
Martin
PS I might even fall in love with you :-))


G
georgev63
Participant
August 7, 2006
It seems that a lot of people are experiencing this problem. What worked in my case was changing the connection settings in Dreamweaver to use the driver on the local machine instead of the driver on the testing server and it now works like a charm. Hope this helps.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices