Skip navigation links

MySQL Forums :: Connector/ODBC :: myodbc doesn't work under putty tunnel while mysqladministrator does


Advanced Search

myodbc doesn't work under putty tunnel while mysqladministrator does
Posted by: Alfonso ()
Date: February 06, 2005 04:13AM

Hello all,

I have a problem trying to connect via ssh tunnel with myodbc. System is as follows

mysql server: linux box with ssh and mysql 4.0.2x (don't remember the version exactly, I think it is 23)

myodbc client: windows XP professional with administrative tools installed and myodbc 3.51.

I follow the following steps:

1- create tunnel to my linux box with putty. Local port is 30000
2- first check of the tunnel is working: telnet localhost 30000 and i get the "welcome string"of the mysql server.
3- second check that the tunnel is working: mysqladministrator can connect to localhost:30000 and i can administer my databases, at least I can see the tables and the databases i have access to.
4- Go to administrative tools->Data Sorces (ODBC)->User DSN->Add->mysql 3.51 ODBC driver
5- Set the following para meters:
server: localhost
user:blabla
password:blabla
port:30000
6- Get the following error message: [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'localhost' (10061)

I have tried 127.0.0.1 instead of localhost without success. A direct connection to the server on port 3306 (not through tunnel) works perfectly but I do need tunnel here. I also tried socket:30000 instead of port, but it didn't work. Also ried System DSN but nothing changed. Any idea of what the problem can be? what I don't understand is why mysqladministrator can use the tunnel and the driver can't. I'm not an expert in windows user by the way. What I want is use ODBC to connect from Access to the mysql database.

I have been through google but I found nothing addressing this problem or something similar so I got no clue of what else to try.

Thanks a lot in advance

Alfonso

Options: ReplyQuote


Subject Written By Posted
myodbc doesn't work under putty tunnel while mysqladministrator does Alfonso 02/06/2005 04:13AM
Re: myodbc doesn't work under putty tunnel while mysqladministrator does Brian Pilati 02/09/2005 05:02PM
Re: myodbc doesn't work under putty tunnel while mysqladministrator does Billy Pilgrim 02/19/2005 04:24PM
Re: myodbc doesn't work under putty tunnel while mysqladministrator does fabio caldas 03/14/2006 10:53PM
Re: myodbc doesn't work under putty tunnel while mysqladministrator does 10/04/2006 10:32AM
Re: myodbc doesn't work under putty tunnel while mysqladministrator does 10/04/2006 11:04AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.