Re: Connecting to a SQL Server
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. -- http://mail.python.org/mailman/listinfo/python-list
Re: Connecting to a SQL Server
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. -- Jarek Zgoda http://jpa.berlios.de/ | http://www.zgodowie.org/ -- http://mail.python.org/mailman/listinfo/python-list
Connecting to a SQL Server
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. -- http://mail.python.org/mailman/listinfo/python-list
Re: Connecting to a SQL Server
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/ -- http://mail.python.org/mailman/listinfo/python-list