Error trying to connect to DB

[MidOhioIT]

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?

[Newsgroup_User]

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?
>

[MidOhioIT]

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: *****

[Newsgroup_User]

What version of ColdFusion and MySQL are you trying to use?

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


"MidOhioIT" <webforumsuser@macromedia.com> wrote in message
news:ftm12n$sua$1@forums.macromedia.com...
> 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: *****
>

[MidOhioIT]

ColdFusion MX Version: 7.0.091690

MySql : version 5.0.22-community-nt

[Newsgroup_User]

you need updated mysql connector driver to use with ver 5.
download mysql-connector-j from mysql website.

maybe Ken can provide you with an adobe kb link which describes the
procedure - i can't find it now...

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/

[MidOhioIT]

This has been resolved with the driver download and a restart of the server. Thanks.