Skip to main content
Participant
February 19, 2008
Question

dreamweaver cs3 database connection error

  • February 19, 2008
  • 2 replies
  • 893 views
Please help.
I am trying to connect to a remote server to develop a php application with a mysql database. I have taken all the steps, but when I try to connect using the dreamweaver application database connections, I get this error "an unidentified error has occurred." I am able to connect remotely via MySql administrator.
I am working on a Mac with Tiger 10.4.11.

I have set my testing server to be the same as my remote server? does this need to be different?

php and mysql are on the same machine, so I have put in local host as the MySql server in the MySQL connection panel.

I could really use some help on this. Thanks.

This topic has been closed for replies.

2 replies

February 29, 2008
I'm having the same error too.
Participating Frequently
March 3, 2008
I am using DW CS3 as well. Was able to connect to the db server PRIOR to PHP being upgraded on our webserver. We were using PHP 5.24 and upgraded to PHP 5.25. Now I can't connect via DW, although I can still connect via the command line. Egads! just realized I upgraded from CS2 to CS3 in the meantime. Perhaps this is a plot to try to get us to switch to CF???
Participating Frequently
March 3, 2008
I managed to figure out why this wasn't working for me - don't know if this will help anyone else.

Make sure your HTTP Address in the Local Info window exactly matches your URL prefix in the Testing Server window. Fixed my problem.

BTW, I have ALWAYS made my testing server and my remore server the same and have never run into any issues from a programming standpoint.
Inspiring
February 21, 2008
A testing server is normally local, that is on your local server or
machine. The remote server is on your isp computers. NO, I would not
make local and remote the same. Does your isp allow to attach remotely
to the database? Some do and more, in my experience, do not; you have
to use what is available on their site.

If you can open MySQL control center, query analyzer, etc then you know
that MySQL is working.

What is the connection string you are using?

cardinalsyne wrote:

> Please help.
> I am trying to connect to a remote server to develop a php
> application with a mysql database. I have taken all the steps, but
> when I try to connect using the dreamweaver application database
> connections, I get this error "an unidentified error has occurred."
> I am able to connect remotely via MySql administrator.
> I am working on a Mac with Tiger 10.4.11.
>
> I have set my testing server to be the same as my remote server?
> does this need to be different?
>
> php and mysql are on the same machine, so I have put in local host
> as the MySql server in the MySQL connection panel.
>
> I could really use some help on this. Thanks.



--