ODBC Connection Error

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default ODBC Connection Error

    Hello,
    I am running the Developer version of CF and I am trying to make one simple
    connection to MySQL database, however, i keep getting an error message when I
    try and set up the connection. This is the message I get:

    Connection verification failed for data source: mysqlcf_jbspeckh
    java.sql.SQLException: Cannot connect to MySQL server on 64.202.189.150:3600.
    Is there a MySQL server running on the machine/port you are trying to connect
    to? (java.net.ConnectException)
    The root cause was that: java.sql.SQLException: Cannot connect to MySQL server
    on 64.202.189.150:3600. Is there a MySQL server running on the machine/port you
    are trying to connect to? (java.net.ConnectException)

    If someone could help explain to me what this means that would be great.
    Thanks.

    John Speckhard

    climbrainer Guest

  2. Similar Questions and Discussions

    1. Error in ODBC connection to Pick D3 database in CF 7.0.1
      I've updated CF 5.0 over Windows 2000 to CF 7.0.1 and queries over Pick D3 ODBC conection give an "ColdFusion MX 7 ODBC Server" error: "ColdFusion...
    2. Create ODBC connection
      I figure if the CF Administrator can create an ODBC connection for CF, and the Administrator is just a CF application, we, as application...
    3. create ODBC connection in CF?
      Is there a way to create ODBC DSNs via code? Even if I have to execute something in another language...
    4. ODBC Connection
      I created dynamicxls in system DSN to connect to another server J: it showed J:/weekly/suspenselist.xls then I created Data source in...
    5. Connection string - ODBC vs OLEDB and Unspecified Error
      This one has me stumped and I was wondering if anyone might have a solution... Using this connection string ...
  3. #2

    Default Re: ODBC Connection Error

    What version of mySQL and CF MX are you using? Are you trying to connect to a
    local database (ie. on your machine) or remote database? If it is a local
    database, try using "localhost" or "127.0.0.1" instead of "64.202.189.150". If
    it is a remote database, does the mySQL server on 64.202.189.150 allow
    connections from your IP address?



    mxstu Guest

Posting Permissions

  • You may not post new threads
  • You may 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