Friday, March 9, 2012

ODBC using SSH

Hello!
I am trying to use the ODBC services via an SSH connection.
What is the easiest way of doing this? Are there any ready-made software out
there than I can use to connect?
Thank you!
-BahmanHi,
ODBC has no clue about SSH. What you need to do is to use an SSH client
that supports tunnelling, like Putty
(http://www.chiark.greenend.org.uk/~sgtatham/putty/)
You will have to read Putty's documentation to see how to setup
tunneling. Once SSH tunelling is setup, you simply put "localhost" as
the remote server name in ODBC DSN. I have this setup on my end. Here is
what I do.
Client on
Internet -> Linux machine via SSH -> MS SQL Server
Regards.
Bahman wrote:
> Hello!
> I am trying to use the ODBC services via an SSH connection.
> What is the easiest way of doing this? Are there any ready-made software o
ut
> there than I can use to connect?
> Thank you!
> -Bahman
>

No comments:

Post a Comment