SQL Server 2008R2 databases via Python 2.7 and Windows XP and higher

Tim Golden mail at timgolden.me.uk
Fri Jun 17 11:13:57 EDT 2011


On 17/06/2011 16:01, python at bdurham.com wrote:
> Looking for some real-world advice on what is the best way to access MS
> SQL Server 2008R2 databases via Python 2.7 running under Windows XP,
> Vista, and Windows 7 and Windows Server 2005 and 2008.
> Based on my research, here's my list of choices:
> mxODBC
> http://www.egenix.com/products/python/mxODBC/
> pyOdbc 2.1.8
> http://code.google.com/p/pyodbc
> pyMSSQL 1.02
> http://code.google.com/p/pymssql

I use pyodbc (and have done for some years) without any problems
at all. Barring the one or two issues I've logged which are
being addressed. (grin). We use pretty much exactly the mixture
of platforms you're describing.

TJG



More information about the Python-list mailing list