MYSQL 5.0 connection

[utardylan]

i had follow the instruction

Note: Connector/J version 3.1.11 and higher cannot be used with ColdFusion MX
7 because of MySQL bug 13469. Connector/J 3.1.10 should be used instead for
ColdFusion MX 7 until this MySQL bug is fixed. All -Connector/J version 3.0
releases and all version 3.2 releases work with ColdFusion MX 7.

-Extract the mysql-connector-java-3.{n}-bin.jar file from the downloaded
archive file.

-Save the mysql-connector-java-3.{n}-bin.jar file in the cf_root/WEB-INF/lib
directory.

-Restart the ColdFusion MX server.

-Add a new data source to the ColdFusion MX Administrator, using the driver
option Other.

-Enter the JDBC URL: jdbc:mysql://[host]:[port]/[database]

-Enter the Driver Class: com.mysql.jdbc.Driver

-Complete username/password, and adjust other data source settings, if needed.

-.Submit the data source for verification.


but still got error occurs :

???????????????????: hm_account
java.sql.SQLException: Cannot connect to MySQL server on hm:3306. Is there a
MySQL server running on the machine/port you are trying to connect to?
(java.net.UnknownHostException)
????? :java.sql.SQLException: Cannot connect to MySQL server on hm:3306. Is
there a MySQL server running on the machine/port you are trying to connect to?
(java.net.UnknownHostException)

[BKBK]

Is the MySQL service running? Check in Control Panel => Administrative Tools =>
Services. Is there a subdirectory in the data directory of your MySQL
installation, that has the same name as the [database] setting in your
JDBC URL?

[Mountain Lover]

the newest driver works with 5+... 3.1.13
and that previous bug has been fixed in the 3.1.13 driver. I use the
latest driver for connections to 4.0, 4.1 & 5.0 on my dev box.
As BKBK suggested, make sure MySQL is running, no firewall issues, port
number is correct, etc.
HTH,
--
Tim Carley
[url]www.recfusion.com[/url]
[email]info@NOSPAMINGrecfusion.com[/email]