Chris,
is this the article you followed from Macromedia?
How to use MySQL 4.1 with ColdFusion MX http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253
I followed these steps on my Win2k machine without any problem. What OS are you running?
Try entering 127.0.0.1 instead of "localhost".
How are the ID and PWD "automatically populated"? Do you plan to pass them in via <cfquery>? If you didn't enter them in the Datasource form fields, then CF Admin can't verify the connection.
You can verify user access privileges by downloading MySQL Administrator: http://www.mysql.com/products/administrator/
See if you can connect to your database using that ID/PWD with MySQL Query Browser: http://www.mysql.com/products/query-browser/
HTH,
Adrian
Chris Gomez wrote:
----------------------------------------------------------I am trying to set up a MySQL 4.1.7 DSN connection, but i keep getting the following error:
Connection verification failed for data source: dev []java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info.
I have loaded the latest ODBC and JDBC drivers from the MySQL site. I selected MySQL as the driver, then entered the DSN name, schema name and server (localhost, in this case). The user id/pw are automatically populated.
I checked Macromedia's site and tried using the Other ODBC driver and configured it with the JDBC URL and Class data. However, I get the same authentication error.
I've also tried to create a DSN for the mysqltest schema and created a connection for it, either.
any help appreciated.
Thanks,
Chris
To post, send email to [email protected]
To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
