failing to connect to MySQL

[stillwaiting]

WinXP Pro CFMX 6.1(using built in webserver) MySQL 4.1.13a-nt via TCP/IP

Okay, I have tried connecting to my DB following the instructions at
[url]http://www.macromedia.com/go/tn_19170[/url]
using the mysql-connector-java-3.1.10-bin (should I be using the .jar
that ends with -g?)

I have copied the MySQL connector/J to a folder I created at the
following path
C:\CFusionMX\db\mysql_connector\mysql-connector-java-3.1.10-bin.jar
(my understanding was that it didn't matter where it went as long as it
wasn't in wwwroot)
When trying to connect to it I inserted the following info:
Data Source Name = menagerie
JDBC URL = jdbc:mysql://localhost:3306(tried with and without port)
/menagerie
Driver Class = com.mysql.jdbc.Driver
Driver Name =
Username = root
Password = ****************

Upon Submit I receive the following error:
Connection verification failed for data source: menagerie
[]java.sql.SQLException: Unable to instantiate logger class
'com.mysql.jdbc.log.Log4JLogger', exception in constructor?
The root cause was that: java.sql.SQLException: Unable to instantiate
logger class 'com.mysql.jdbc.log.Log4JLogger', exception in constructor?

I also tried the built in MySQL connector and I get the following response:
Connection verification failed for data source: menagerie
[]java.sql.SQLException: Communication failure during handshake. Is
there a server running on 127.0.0.1:3306?
The root cause was that: java.sql.SQLException: Communication failure
during handshake. Is there a server running on 127.0.0.1:3306?

I know that is were the server is because the MySQL Admin says that is
were it is. And there is a db called menagerie.

Ideas?

<just wanting a database>
stillwaiting
</just wanting a database>

[Mountain Lover]

use the 3.0.17ga connector...it works for me on CFMX6.1
HTH
--
Tim Carley
[url]www.recfusion.com[/url]
[email]info@NOSPAMINGrecfusion.com[/email]

[stillwaiting]

Okay, I got it working looking at the thread titled "MySQL 4.1 & CFMX
6.1 connector problems"

It is kind of a long story all of the little things I did but it is now
working. Thanks HTH

stillwaiting

> use the 3.0.17ga connector...it works for me on CFMX6.1
> HTH