I have be running ColdFusion MX (Development Edition) on a local Apache server
without any problems (WinXP SP1, Zone Alarm personal FW). I usually use MS
Access as my datasource but am trying to create a MySQL datasource. I have
installed and created a MySQL db (MYSQLDB) and can successfully log in via the
command prompt. I have verified that MySQL is listening on port 3306. I have
also verified and restarted the CF MX App Server service, CF MX ODBC Agent
service, and CF MX ODBC Server service.

After searching all over the place and trying different solutions, it still
doesn't work! Here's what I've tried so far:

1: Using CF Administrator to create add new MySQL Data Source with the
following info:
- CF Data Source Name: test
- Database: MYSQLDB
- Server: localhost
- Port: 3306
- Username: root
- Password: password

Get the error:
"Connection verification failed for data source: test
[]java.sql.SQLException: Cannot connect to MySQL server on localhost:3306. Is
there a MySQL server running on the machine/port you are trying to connect to?
(java.net.ConnectException)
The root cause was that: java.sql.SQLException: Cannot connect to MySQL server
on localhost:3306. Is there a MySQL server running on the machine/port you are
trying to connect to? (java.net.ConnectException)"

2: Using CF Administrator to create add new ODBC Socket Data Source:

Get the error:
"The ColdFusion MX ODBC Server service is not running or has not been
installed."

3: Downloaded and installed the MySQL Connector J JDBC driver. Saved the
mysql-connector-java-3.{n}-bin.jar file in the cf_root/WEB-INF/lib directory
and restarted the CF MX Server. When using the CF Administrator to add new
Other datasource with the following options:

- CF Data Source Name: test
- JDBC URL: jdbc:mysql://localhost:3306/MYSQLDB
- Driver Class: com.mysql.jdbc.Driver
- Driver Name: (blank)
- Username: root
- Password: password

Get the error:
"Connection verification failed for data source: test
[]java.sql.SQLException: No suitable driver available for test, please check
the driver setting in resources file, error: com.mysql.jdbc.Driver
The root cause was that: java.sql.SQLException: No suitable driver available
for test, please check the driver setting in resources file, error:
com.mysql.jdbc.Driver"

..............

I am running MySQL 5. I have not tried using MySQL Admin. Once I was able to
successfully log in via the cmd prompt, I tried using the CF MX Admin. I
changed the uname/pwd combination and still get the same error.

It seems that the problem is with recognizing my JDBC driver. Is there a
specific location where the driver should be installed? Is there someone I can
configure my CF MX Server to point to the JDBC driver?

What am I doing wrong or missing????
Please Help!