Skip to main content
M
MidOhioIT
Participating Frequently
April 10, 2008
Question

Error trying to connect to DB

  • April 10, 2008
  • 1 reply
  • 804 views
when trying to connect to a mysql database I get the following error in Coldfusion:

Connection verification failed for data source: zipcodes
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?

Does anyone know why this is happening?
This topic has been closed for replies.

1 reply

N
Newsgroup_User
Inspiring
April 10, 2008
Looks like you are using an earlier version of CF. I believe this was fixed
in 7

See if this helps:

http://www.adobe.com/go/5fa26cba

--
Ken Ford
Adobe Community Expert - Dreamweaver
Fordwebs, LLC
http://www.fordwebs.com


"MidOhioIT" <webforumsuser@macromedia.com> wrote in message
news:ftjogh$b03$1@forums.macromedia.com...
> when trying to connect to a mysql database I get the following error in
> Coldfusion:
>
> Connection verification failed for data source: zipcodes
> 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?
>
> Does anyone know why this is happening?
>

M
MidOhioITAuthor
Participating Frequently
April 10, 2008
Ken,
Thanks for your help. I am new at coldfusion so don't be afraid to state the obvious... I now get this error:

Connection verification failed for data source: zipcodes
java.sql.SQLException: No suitable driver available for zipcodes, please check the driver setting in resources file, error: null
The root cause was that: java.sql.SQLException: No suitable driver available for zipcodes, please check the driver setting in resources file, error: null

This is the settings that I have in literal text:
CF DATA SOURCE NAME: zipcodes
JDBC URL: jdbc:mysql://127.0.0.1:3306/zipcodes
DRIVER CLASS: com.mysql.jdbc.Driver
USER NAME: zip_user
PASSWORD: *****
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices