Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #7827 > unrolled thread

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

Back to article view | Back to comp.lang.python

This discussion starts older than the indexed window; earlier articles aren't shown. The article labeled Started by below is the oldest one visible, not the original post.

Contents

  Re: SQL Server 2008R2 databases via Python 2.7 and Windows XP and higher Ethan Furman <ethan@stoneleaf.us> - 2011-06-17 08:34 -0700

#7827 — Re: SQL Server 2008R2 databases via Python 2.7 and Windows XP and higher

python@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~

[toc] | [standalone]

Back to top | Article view | comp.lang.python

csiph-web