dreamweaver cs3 database connection error

Report · Feb 19, 2008

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.

Report · Feb 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.

--

Report · Feb 29, 2008

I'm having the same error too.

Report · Mar 03, 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???

Report · Mar 03, 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.

Report · May 02, 2008

Thanks EsmereldaPea. I had the same problem and that fixed it. There should be a better description of the error when it occurs. There is really nothing to go on with "an unidentified error has occurred" other than we know it is access related.