all groups > sql server odbc > november 2005 >
You're in the

sql server odbc

group:

ODBC using SSH


ODBC using SSH Bahman
11/29/2005 9:02:02 AM
sql server odbc:
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!

-Bahman
Re: ODBC using SSH Dennis Black
12/9/2005 9:58:23 AM
Hi,

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.



[quoted text, click to view]
AddThis Social Bookmark Button