Unix Technical Forum

ODBC using SSH

This is a discussion on ODBC using SSH within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> Hello! I am trying to use the ODBC services via an SSH connection. What is the easiest way of ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > MS SQL ODBC

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 10:02 PM
=?Utf-8?B?QmFobWFu?=
 
Posts: n/a
Default 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!

-Bahman

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-27-2008, 10:02 PM
Dennis Black
 
Posts: n/a
Default Re: ODBC using SSH

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.



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 out
> there than I can use to connect?
>
> Thank you!
>
> -Bahman
>

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 05:23 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com