DreamweaverMX and a MySQL database

Forum|Forum|19 years ago
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

Server side applications

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!

N

Newsgroup_User

Inspiring

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

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

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

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/

N

Newsgroup_User

Inspiring

Dax Trader wrote:
> 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 believe it to be the most asked question because a large number of
people don't have a properly installed PHP/MySQL setup, or they fail to
define the testing server correctly in their site definition.

> I will be delighted, estactic, and eternally in you debt if you can help me
> sort this. :-))

Well, I'll try.

> PS I might even fall in love with you :-))

Please don't. I don't think my wife would approve. ;)

Open php.ini and make sure the semicolon is removed from the beginning
of these two lines:

;extension=php_mbstring.dll
;extension=php_mysql.dll

Add this line:

extension=php_mysqli.dll

Save php.ini, and restart Apache.
Load a page with <?php phpinfo(); ?> into a browser, and scroll right
down. Check that you have sections headed mysql and mysqli. Check that
the value of Client API version in those sections is at least 5.0.x.

Check your testing server setup.

The testing server folder must be in the Apache document root.
The URL prefix must be http://localhost/name_of_testing_folder/

Unless there is something unusual about your system, it should then work.

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

Hi
Thanks for all your help to date. Unfortunately I now have another error message when trying to connect to the MySQL database.

That message reads "Your PHP server doesnt have the MySQL module loaded or you cant use the MYSQL_(p)connect functions"

I can now confirm that Apache is running fine, MySQL is installed (I created a small test dbase with it to test the connection)

Apache is integrated with PHP5 as I can use the Live Data View facility in DreamWeaver.

Can you shed some more light :-))

Martin

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded