Can't connect to database: "An unknown error has occurred"

I've installed the PowerCMS Builder extension into Dreamweaver CS5 Mac, and when I try to add a content area using it, I get this error (actually, it's "unidentified error") when trying to test my connection. I know all the info is correct (server name, database, username, password). I've uninstalled the extension and files, and reinstalled a couple of times with no change. Is there something I'm missing? Why can't I connect? I'm sure the database is there and set up correctly. I've used PowerCMS "standalone" version a few times now with no trouble, and I've set up my databases the same way. Any clue as to what this "unknown error" might be?

In the Dreamweaver Site Definitions, How have you configured the testing server?

When testing a database connection, Dreamweaver uses the Sites testing server settings to connect to your testing server.The Unidentified error suggests that the testing Server settings are not correct.

See the "Defining a Dynamic Site in Dreamweaver" tutorial on the learning resources page:

resources.php

Hi Jason,

I'm not using a testing server, I'm publishing straight to the web server (Network Solutions is my host). Should I set up the netsol site as my testing server?

double check with the host that the MySQL server will allow connections from an outside computer.

If the MySQL Server will allow the connection, then you should be able to set ti to act as both remote and testing server.

I find that using the remote server as a testing server can be problematic in Dreamweaver, though.

Even though it can be done, it's not a recommended development set up.

it is a better idea to have a local testing server for development then publish to the remote server.

Thanks, Jason. I successfully set up a testing server here on my Mac with MAMP, and it seems to be working well. Now to figure out how to set it up on the remote server. I may be back here with more questions. :)

on the learning resources page, see the "Managing your live database settings" tutorial for details on setting your site to go live.

Thanks. I've successfully set up the database on the remote server, but now all my content is in my local database. Is there an easy way to move the database from my local machine to the remote server so I don't have to recreate all new content regions?

Using PHPMyAdmin, you can export the data from your local database as an sql file, then import it to the remote database.

Thanks, Jason. I stayed up late Googling and figured that out. The *extremely* frustrating part was the discovery that the import doesn't work in Safari (Mac). I must've tried a dozen times, and it timed out every time with an error. This morning I thought I'd try Firefox, because, well, why not. And it imported the file in seconds. All is working great now. Thanks for your help.

glad to hear you have it sorted.