By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,050 Members | 1,019 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,050 IT Pros & Developers. It's quick & easy.

Connecting to a SQL Server

P: n/a
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.

Jul 18 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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/
Jul 18 '05 #2

P: n/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?

Thanks.

Jul 18 '05 #3

P: n/a
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/
Jul 18 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.