python connection to mssql from windows box

[Josh Close]

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

[Mark J. Nenadov]

On Wed, 29 Sep 2004 21:05:32 -0500, Josh Close wrote:

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

Josh,

I think you will either need to:

A. use win32com to call ADO

or

B. use odbc

- -
Mark J. Nenadov
http://www.pythonbyte.com

[Elbert Lev]

Josh Close <na****@gmail.com> wrote in message news:<ma**************************************@pyt hon.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