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]

Re: python connection to mssql from windows box

On Wed, 29 Sep 2004 21:05:32 -0500, Josh Close wrote:
[color=blue]
> 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[/color]

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]

Re: python connection to mssql from windows box

Josh Close <narshe@gmail.c om> wrote in message news:<mailman.4 112.1096509934. 5135.python-list@python.org >...[color=blue]
> 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[/color]

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