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

Tim Golden mail at timgolden.me.uk
Wed Mar 2 10:34:08 CET 2011

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:


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):



More information about the Tutor mailing list