What's the best technology for connecting from linux to MS SQL Server using python? ODBC?

A:

I'm just learning Python myself, but it seems like there are Python libraries that look more like Java JDBC drivers. Google found these articles about SQLObject and cx_Oracle.

duffymo 2009-03-01 00:32:52

+2 A:

pymssql, the simple MS SQL Python extension module.

Bill the Lizard 2009-03-01 00:33:49

+3 A:

You may find this topic helpful:

http://stackoverflow.com/questions/289978/whats-the-simplest-way-to-access-mssql-with-python-or-ironpython

Randolpho 2009-03-01 00:36:48

The best answer for the other question is SQLAlchemy, an ORM layer. Yikes, I just want to run a couple of insert statements from a little python script. I don't need an ORM layer for that.

Corey Trager 2009-03-01 13:34:54

Maybe you do, but don't know it yet. Don't build too much technical debt on your first iteration.

Randolpho 2009-03-02 00:16:13

A:

I decided that pyodbc was the best fit. Very simple, stable, supported:
http://code.google.com/p/pyodbc/

Corey Trager 2009-03-01 13:38:49

+1 A:

FreeTDS

mluebke 2009-03-02 04:30:41

ansaurus

tags:

views:

answers:

What's the best technology for connecting from linux to MS SQL Server using python? ODBC?

related questions