python connection to mssql from windows box

J

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
 
M

Mark J. Nenadov

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
 
E

Elbert Lev

Josh Close said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,744
Messages
2,569,483
Members
44,901
Latest member
Noble71S45

Latest Threads

Top