dreamweaver cs3 database connection error

[cardinalsyne]

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.

[Binh Nguyen]

Post by cardinalsyne
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.

Hello,
I have the same error. If I use Dreamweaver MX, I can connect to MySQL
5.1 but if I use Dreamweaver CS3 I cannot connect to mySQL. Adobe also
have missspelling on this error too. It's "An unidentifed error
occurred." --> unidentified NOT unidentifed.
When I'm trying to connect to MySQL 5.1, this popup window doesn't let
me connect. Very frustrated. MySQL 5.1 Admin and phpMyAdmin tool works
fine. I'm using the same username and password and ofcourse localhost
as hosting server.

[Philo]

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?

Post by cardinalsyne
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.

--

[ruizismael]

I'm having the same error too.

[EsmereldaPea]

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

[EsmereldaPea]

I managed to figure this out - don't know if this will help anyone else - make
sure your [b]HTTP Address[/b] in the [b]Local Info[/b] window matches your
[b]URL prefix[/b} in the [b]Testing Server[/b] window. Fixed my problem.

[SailorBr549]

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.

[b***@gmail.com]

http://forums.adobe.com/thread/1040309