Connecting to a SQL Server

[ttmi]

Hi,

I am trying to write a python script to connect to a remote SQL Server
on windows. The user name and password should be encrypted and
transmitted over network using ssh. Any idea how this can be done?

Thanks a lot.

 

[Jarek Zgoda]

ttmi napisa³(a):

I am trying to write a python script to connect to a remote SQL Server
on windows. The user name and password should be encrypted and
transmitted over network using ssh. Any idea how this can be done?

Using native MSSQL2K ADO (OLEDB) provider encrypted connection -- see
MSDN on using ADO to connect to MSSQL. You can interface ADO from Python
with adodbapi.

This is simplest, I don't pretend it's also best.

 

[ttmi]

Ok. Understood we can interface ADO from python and connect to MS SQL.
But still not so clear where SSH comes in? Can elaborate more?

Thanks.

 

[Jarek Zgoda]

ttmi napisa³(a):

Ok. Understood we can interface ADO from python and connect to MS SQL.
But still not so clear where SSH comes in? Can elaborate more?

No SSH is involved in this case -- MSSQL OLEdb provider offers SSL
encrypted connection out of the box, just set appropriate property to
true and ensure that client library uses TCP.

Anyway, SSH is just remote shell, so it make no sense for me when it
comes to retrieving data from database.