python connection to mssql from windows box

Elbert Lev elbertlev at hotmail.com
Thu Sep 30 11:56:33 EDT 2004


Josh Close <narshe at gmail.com> wrote in message news:<mailman.4112.1096509934.5135.python-list at python.org>...
> Is there a python module that uses the mssql client tools to connect
> to mssql? When you install php on windows and you want mssql
> connectivity, you need the client tools and it uses that api to
> connect.
> 
> I know there is an ADO connection for postgres to connect from
> windows, but that's different. Is there anything like this for python?
> 
> -Josh

You may use ODBC or ADO (<http://sourceforge.net/projects/adodbapi>).
ODBC comes with win32 extensions and is seamlessly integrated with dbi
(1) . So when you write your script, besides of opening the connection
there is no real difference what kind of relational database is used.
ADO supports dbi-2.0.

Good luck



More information about the Python-list mailing list