Connecting to a SQL Server

Jarek Zgoda jzgoda at gazeta.usun.pl
Mon Mar 28 08:46:20 EST 2005


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.

-- 
Jarek Zgoda
http://jpa.berlios.de/ | http://www.zgodowie.org/



More information about the Python-list mailing list