Creating an ODBC connection to a MySQL DB

[canstocker]

Hello everyone,

I just downloaded an ODBC driver for mySQL. I'm trying to create a link to one of my account's databases.

However, when I try this (trying with domain, IP, cpanelXX.gzo.com) I get an error a "can't connect" error. I'm using the default port 3306.

Is what I'm doing possible? If so, what am I doing wrong?

Dan.

[james]

Dan,

This is because direct (external) access to the databases on the dathorn servers are disabled.

There is a workaround for this - see http://forums.dathorn.com/showthread.php?t=216 for details.

James

[canstocker]

Thanks James!

It worked!

[james]

No problem

It does seem annoying to start with, but it eliminates the possiblity of someone else remotely connecting to your mysql database. Given this, I'd say it's worth the little bit of extra hassle to get it working.

Cheers,

James