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
