Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user

I get this error on loading a results page, however, I could test the query from within Dreamweaver with no problem.

Problem was that there was a $ sign in the database password, which is apparently not a legal character for a MySQL password.

I have included that just to help out others who stumble on the same error. However, I still have an issue.

I created some pages using a MySQLi connect string rather than the MySQL connect string I have always used. I did this from within the DataAssist wizard. Like the other page, I can successfully run the query using TEST in Dreamweaver, but on loading the page I get this error.

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in .....
and
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in

I am stumped. The server supports MySQLi, so why is it not recognizing the page? If I change the connection string to the MySQL version, the page runs just fine.

The error is referring to mysql functions and not mysqli... but you imply that you are using mySQLi on the page... so there seems to be a disconnect.

Updating a page to use mysqli isn't just a matter of updating the connection. It requires updating all of the recordsets, inserts, and updates as well. My guess is that you updated the connection, but still have code on the page that refers to the mysql connection and that no longer works.

I think you are half right.

I did this with data assist wizard. First step is to create a connection and you have a choice between mysql or mysqli. I chose mysqli but the wizard created pages for mysql.

If I point to the mysql connection script the pages work fine.

Why did it not create mysqli pages to match the connection chosen?

Data Assist hasn't been updated to work with MySQLi yet. We will be adding that in the next major update. For now you need to use a standard MySQL connection to work with Data Assist.