Results 1 to 12 of 12

Thread: Mysql ODBC

  1. #1
    Join Date
    Nov 2003
    Posts
    3

    Unanswered: Mysql ODBC

    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?

  2. #2
    Join Date
    Oct 2003
    Posts
    63
    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.

  3. #3
    Join Date
    Nov 2003
    Posts
    3
    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.

  4. #4
    Join Date
    Oct 2003
    Posts
    63
    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.

  5. #5
    Join Date
    Nov 2003
    Posts
    3
    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.

  6. #6
    Join Date
    Oct 2003
    Posts
    63
    Originally posted by danharlan
    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.

  7. #7
    Join Date
    Nov 2003
    Posts
    91

    Re: Mysql ODBC

    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

  8. #8
    Join Date
    Oct 2003
    Posts
    63

    Re: Mysql ODBC

    Originally posted by vanekl
    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.

  9. #9
    Join Date
    Nov 2003
    Posts
    91

    Re: Mysql ODBC

    Originally posted by khibinite
    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.

  10. #10
    Join Date
    Oct 2003
    Posts
    63

    Re: Mysql ODBC

    Originally posted by vanekl
    You're not following
    Sorry, I didn't notice your words about concrete port number, I meant you said about telnet at all. Sorry again.

  11. #11
    Join Date
    Mar 2004
    Posts
    1
    Thanks guys, that was a helpful discussion!

  12. #12
    Join Date
    Mar 2004
    Posts
    2

    thanx

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

Posting Permissions

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