Coldfusion / ODBC not working

K

kjp

Guppy
I've created an ODBC connection to my MySQL database in the control panel.

For the 'server' I've used both the IP address of the MySql Server and the host that I login into with FTP, but neither are working.

I get the following error on my coldfusion page:

Error Executing Database Query.
SQLException while attempting to connect: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'wincf2.jodoshared.com' (10061)

Please try the following:

* Enable Robust Exception Information to provide greater detail about the source of errors. In the Administrator, click Debugging & Logging > Debugging Settings, and select the Robust Exception Information option.
* Check the ColdFusion documentation to verify that you are using the correct syntax.
* Search the Knowledge Base to find a solution to your problem.

Browser Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.3) Gecko/20070309 Firefox/2.0.0.3
Remote Address 68.90.31.2
Referrer
Date/Time 09-May-07 11:57 AM
Click to expand...

How exactly am I supposed to configure the ODBC connection?

Here's my current settings:

DSN - TheNameIGaveIt
Server - Tried MySQL server's IP address (204.14.108.61) and my ftp address (wincf2.jodoshared.com)
Database - My MySQL Db Name
Description - yadda ...
UID - my MySQL Login
PWD - my MySQL Passworde
Port - 3306
Option - 16
ColdFusion MX DSN record - Is set to ON
Click to expand...

I really need to get connected so I can start using the db info.

Please help.

Thanks. :)
 
You must log in or register to reply here.
Back
Top