Thanks! Will definitely try that when I get to the office tom. I am using CF for
a very simple db-driven application. Hence, i did not upgrade and stick with the
free developer edition.

--- On Tue, 6/30/09, Kraegan <rprejean@...> wrote:


From: Kraegan <rprejean@...>
Subject: [coldfusion-howto] Re: Very Basic: Connecting MySQL to ColdFusion
To: coldfusion-howto@yahoogroups.com
Date: Tuesday, June 30, 2009, 9:50 AM








I believe the issue that you are running into is the one that plagues older
ColdFusion engines. Fortunately, it is an easy fix. You must download the
Jconnector and and install it then create your data source connection using
"Other" and manualy connect. The problem is ColdFusion MX does not recognize
MySQL 5 or it's drivers as a native connection since MySQL 5.+ came out years
after CF MX.

See Adobe's technote here:
http://kb2.adobe. com/cps/185/ tn_18591. html

This is specific to MySQL 5.5. Google "Coldefusion Jconnector" and search out
the specific versions that you are dealing with if necessary.

Once you have installed the jar file once, you will not need to do so again.
However, keep the connector instructions handy because you will need to make a
generic connection to any database that you create.

Hope this helps.

--- In coldfusion-howto@ yahoogroups. com, A Abaya <aj_abaya@.. .> wrote:
>
>  
> I have a very basic inquiry: I installed MySQL Server 5.1, and have MySQL ODBC
3.51 driver in my terminal. ColdFusion MX was successfuly installed and I was
able to log on to the Administrator page. I was also able to connect to MySQL
and the ODBC as well. I am not sure though why when I define the data source on
the CF page, I get the error message:
>  
>  Connection verification failed for data source: OFAC
> []java.sql.SQLExcep tion: Communication failure during handshake. Is there a
server running on localhost:3306?
> The root cause was that: java.sql.SQLExcepti on: Communication failure during
handshake. Is there a server running on localhost:3306?
>  
> IIS, webserver, Jrun are all installed. Could it just be an issue on the
version or something?
>  
> Here is a copy of the system information:
>  
>
>
>
>
> System Information
>
>   Server Details
>
>
>   Server Product  
>
>   ColdFusion MX
>
>
>   Version  
>
>   6,1,0,63958
>
>
>   Edition  
>
>   Developer
>
>
>   Serial Number  
>
>   Developer
>
>
>   Operating System    
>
>   Windows XP
>
>
>   OS Version  
>
>   5.1
>
>   JVM Details
>
>
>   Java Version  
>
>   1.4.2
>
>
>   Java Vendor  
>
>   Sun Microsystems Inc.
>
>
>   Java Vendor URL  
>
>   http://java. sun.com/
>
>
>   Java Home  
>
>   C:\CFusionMX\ runtime\jre
>
>
>   File Separator  
>
>   \
>
>
>   Path Separator  
>
>   ;
>
>
>   Line Separator  
>
>   Chr(13)
>
>
>   User Name  
>
>   SYSTEM
>
>
>   User Home  
>
>   C:\
>
>
>   User Dir  
>
>   C:\CFusionMX\ runtime\bin
>
>
>   Java VM Specification Version  
>
>   1.0
>
>
>   Java VM Specification Vendor  
>
>   Sun Microsystems Inc.
>
>
>   Java VM Specification Name  
>
>   Java Virtual Machine Specification
>
>
>   Java VM Version  
>
>   1.4.2-b28
>
>
>   Java VM Vendor  
>
>   Sun Microsystems Inc.
>
>
>   Java VM Name  
>
>   Java HotSpot(TM) Server VM
>
>
>   Java Specification Version  
>
>   1.4
>
>
>   Java Specification Vendor  
>
>   Sun Microsystems Inc.
>
>
>   Java Specification Name  
>
>   Java Platform API Specification
>
>
>   Java Class Version  
>
>   48.0
>
>
>
>
> [Non-text portions of this message have been removed]
>



















[Non-text portions of this message have been removed]