Skip to main content
Participating Frequently
January 14, 2010
Question

Cannon't create datasource

  • January 14, 2010
  • 2 replies
  • 1011 views

I go to add a datasource into Coldfusion Administrator and I get a weird error. which is this error.

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException:
Could not create connection to database server. Attempted reconnect 3
times. Giving up.
The root cause was that:
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException:
Could not create connection to database server. Attempted reconnect 3
times. Giving up.

I use wamp server with Apache and MySQL 5.1.2.3(I think thats the version), I was told that I'd need to download JRun but I dunno, if that's my problem or not I thought Coldfusion 9 came with it.

Any help would be very kind thank you in advance.

    This topic has been closed for replies.

    2 replies

    Inspiring
    January 30, 2010

    This error typically means a TCP connection can not be established. What do you get when you go to the command line and run "telnet localhost 3306"?

    Inspiring
    January 30, 2010

    Did you try using MySQL's own JDBC driver?

    http://dev.mysql.com/downloads/connector/j/

    --

    Adam

    TivoilosAuthor
    Participating Frequently
    January 30, 2010

    I don't know how to install that using Wamp.


    Inspiring
    January 30, 2010

    Doesn't the D/L contain a readme file?

    What did you do to try to find out how to install it?

    --

    Adam