Professional Web Applications Themes

problem connecting from cf 6.0 to mysql 5 - Coldfusion Database Access

Hey guys, Heres my problem I can't connect to mysql after i upgraded to v5 it says: Connection verification failed for data source: eval java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. The root cause was that: java.sql.SQLException: SQLException occurred in JDBCPool while attempting to connect, please check your username, password, URL, and other connectivity info. It says to check username and stuff but i can connect with mysql administrator no problem. Do any of you have an idea? Thx in advance Jasper...

  1. #1

    Default problem connecting from cf 6.0 to mysql 5

    Hey guys,

    Heres my problem
    I can't connect to mysql after i upgraded to v5
    it says:

    Connection verification failed for data source: eval
    java.sql.SQLException: SQLException occurred in JDBCPool while attempting to
    connect, please check your username, password, URL, and other connectivity info.
    The root cause was that: java.sql.SQLException: SQLException occurred in
    JDBCPool while attempting to connect, please check your username, password,
    URL, and other connectivity info.

    It says to check username and stuff but i can connect with mysql administrator
    no problem.

    Do any of you have an idea?

    Thx in advance
    Jasper

    jaspers_cool Guest

  2. #2

    Default Re: problem connecting from cf 6.0 to mysql 5

    What version of ColdFusion are you on, and what vintage of MySQL JDBC driver
    (MySQL Connector)? Perhaps you may need to update your driver. This is one
    [url]http://www.macromedia.com/go/tn_19170[/url] that may apply.

    Phil



    paross1 Guest

  3. #3

    Default Re: problem connecting from cf 6.0 to mysql 5

    Thx for the reply, yeah maybe that is it.
    But when i choose other in ColdFusion it shows an error.

    Maybe i should just install everything all over again.
    jaspers_cool Guest

  4. #4

    Default Re: problem connecting from cf 6.0 to mysql 5

    Mx6 only works with the 3.0.17 MySql driver.
    HTH
    --
    Tim Carley
    [url]www.recfusion.com[/url]
    [email]infoNOSPAMINGrecfusion.com[/email]
    Mountain Lover Guest

  5. #5

    Default Re: problem connecting from cf 6.0 to mysql 5

    Jep it works now after i reinstalled everything and used the new jdbc drivers.

    Thank god i tried it on my testserver first.

    I guess you're both right but i'll mark the first post as the answer.

    thx for helping
    Jasper

    jaspers_cool Guest

  6. #6

    Default Re: problem connecting from cf 6.0 to mysql 5

    Thank god i tried it on my testserver first.

    Ain't that what they are for? ;)

    Phil
    paross1 Guest

  7. #7

    Default Re: problem connecting from cf 6.0 to mysql 5

    BTW...here is a quick link to the [url]http://dev.mysql.com/downloads/connector/j/3.0.html[/url].
    AustinBoy Guest

Similar Threads

  1. Problem connecting MySQL in MX Admin Panel
    By Slowtroll in forum Coldfusion Database Access
    Replies: 0
    Last Post: April 3rd, 01:25 PM
  2. connecting mysql
    By dummmmmbo in forum Dreamweaver AppDev
    Replies: 1
    Last Post: March 1st, 12:04 AM
  3. beginner question, problem connecting to mysql
    By ariel in forum PHP Development
    Replies: 1
    Last Post: May 7th, 05:18 PM
  4. PostgreSQL/mySQL: connecting, login code problem.
    By Tekker in forum PHP Development
    Replies: 2
    Last Post: February 28th, 01:22 AM
  5. problem connecting to mySQL
    By Tom Thackrey in forum PHP Development
    Replies: 4
    Last Post: July 9th, 11:36 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139