[Tutor] Alternatives to pymssql to work with MS SQL Server

[Tim Golden]

On 02/03/2011 09:22, Emmanuel Ruellan wrote:
> I installed Python 2.6 and pymssql on a machine, but as soon as I import
> pymssql, it crashes.
>
> It looks like this is a known problem:
> http://code.google.com/p/pymssql/issues/detail?id=2
>
> What alternatives to pymssql do you recommend? I just want to be able to
> perform some simple queries on an MS SQL Server database.

I use pyodbc:

   http://code.google.com/p/pyodbc/

because I tend to operate at the raw-SQL level.
But if you want a rather higher-level interface then
sqlalchemy is definitely your friend (which uses pyodbc
under the covers by default):

   http://www.sqlalchemy.org/

TJG