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

Groups > comp.lang.python > #7827

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

Show all headers | View raw

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~

Back to comp.lang.python | Previous | Next | Find similar | Unroll thread

Thread

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

csiph-web