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

[Ethan Furman]

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

My usage is extremely light, but pyodbc is working well for me.  I have 
not tried the others, so they may also have these pyodbc features: name 
referencing in returned rows (not just indexing); and ability to change 
values in returned rows (local change only).

~Ethan~