I am trying to connect from Excel on my Windows XP Pro PC to Mysql on a Linux box. I am gettiung the following error:
]MySQL\]ODBC 3.51 Driver\ Can't connect to Mysql server on xxx.xxx.xxx.xxx [10061]

I use Phpmyadmin, frp, telnet from this machine no problem. Any thoughts on how to solve this problem?

Hi!

I haven't any trouble with it.

I suppose you should install the MySQL ODBC driver. You could get it from MySQL official web site. After installing of this on your machine you need to create new ODBC alias and tune it for your database. After that you can import data into Excel using such sequence of menus (I point the approx. translation because I have Excel in Russian) Data->Import external data->Import data. Then you shoul select the new connection to the datasource in the dialog and then select ODBC DSN in the wizard. I hope then you will get how to tune final neccesary actions to get your data.

Hope it helps.

Sorry my poor English.

I'm sorry I didn't specify previously but I have iunstalled the driver and the rror I am getting is in my previous mesage.

On which machine is phpMyAdmin placed - your or on the DB-server machine? Is there some problems with proxy? Is this DB on the web? Clarify please where is your DB placed.

Both PhpmyAdmin adn the db are on a web server at my host provider. I am able from my windowes desktop to ftp, telnet in to the server and database.

I know exactly not every provider give such access to database on his web-server. They make such settings to restrict it. I'm afraid you couldn't connect to the database from your desktop. At that hoster name their db-host mostly as "localhost". In any case you could relate with your hoster and clarify this situation.

As a variant I'd like to offer you to make the db-dump via phpMyAdmin and import it into the local db to analyze it via any desktop tool.

I'm no expert on this but it sounds to me like
1. an ODBC driver is not installed on the Linux box
OR, if it is, then
2. the provider's firewall is filtering out port 10061.
If you telnet to xxx.xxx.xxx.xxx 10061 your session
will probably be rejected (telnet: Unable to connect to remote host: Connection refused) which means that either your
request never made it past their firewall or nobody (ie ODBC)
is listening on that port.

That's where I'd start.
-lv

He said he worked via telnet fine.

You're not following: I said telnet to port 10061, not port 23.
There is a difference. It appears ODBC listens on port 10061,
MySQL listens to port 3306 (at least I believe that is its
default port), and what you think of telneting is usually set
up to use port 23. If you telnet to the MySQL port you should
get the MySQL database version number, but not much else.
Just because you can telnet to port 23 doesn't mean you can
telnet to any ol' port.
Firewall filter rules are based on port numbers.
It could be as simple as port 10061 is being rejected by the
firewall (I'm guessing the provider uses a firewall).

-lv

P.S. BTW, when telneting to 10061 don't expect to start up
a typical telnet session. All you'll be able to deduce is
whether you're able to reach the port, and if a program
is actually listening to the port.

Sorry, I didn't notice your words about concrete port number, I meant you said about telnet at all. Sorry again.

Thanks guys, that was a helpful discussion!

i'd like to thank as well
the tip about the filtered port was very useful to me - thanx, vanekl