Creating mysql datasource problem

[joeEarl]

I'm using CF version 6.0 and MYSQL 4.0 all... connectivity info is correct but
I get this error message:

[]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.

Does anyone know what the problem is and how to fix it.

Thanks in advance. - Joe

[Charlie-D]

I have exactly the same problem.. I am using CF version 7.0, and MySQL 4.1.10a.
I setup a DSN for a database I have on MySQL and I get the same error listed
here.. My fear is that the driver is listed as (MySQL 3.x). Does CF 7.0 support
MySQL 4.1???

[Charlie-D]

Woops! Sorry about this.. I found the answer right here... DOn't know why my
initial search for "MySql 4" didn't hit this... Search for "MySQL" did though...


[url]http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=6&thread[/url]
id=976427&highlight_key=y&keyword1=mysql

Sorry for adding noise to the forum...

-Charlie