Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!aioe.org!feeder.news-service.com!news2.euro.net!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail Return-Path: X-Original-To: python-list@python.org Delivered-To: python-list@mail.python.org X-Spam-Status: OK 0.003 X-Spam-Evidence: '*H*': 0.99; '*S*': 0.00; '2.7': 0.04; 'subject:Python': 0.06; 'python': 0.08; 'from:addr:ethan': 0.09; 'from:addr:stoneleaf.us': 0.09; 'from:name:ethan furman': 0.09; 'message-id:@stoneleaf.us': 0.09; 'pyodbc': 0.09; 'received:gator410.hostgator.com': 0.09; 'referencing': 0.09; 'subject:2.7': 0.09; '~ethan~': 0.09; 'wrote:': 0.14; '1.02': 0.16; 'received:72.11': 0.16; 'received:72.11.125': 0.16; 'received:72.11.125.166': 0.16; 'rows': 0.16; 'subject: \n ': 0.16; 'cc:addr:python-list': 0.17; 'url:code': 0.17; 'subject:Windows': 0.20; 'header:In-Reply-To:1': 0.21; 'cc:2**0': 0.22; 'cc:no real name:2**0': 0.23; 'values': 0.25; 'windows': 0.26; 'tried': 0.27; '(not': 0.28; 'server': 0.29; 'cc:addr:python.org': 0.30; '2005': 0.31; 'url:products': 0.31; 'usage': 0.32; 'list': 0.33; 'header:User-Agent:1': 0.35; 'running': 0.37; 'change': 0.37; 'extremely': 0.37; 'url:python': 0.38; 'but': 0.38; 'subject:: ': 0.38; 'some': 0.38; 'url:google': 0.38; 'returned': 0.39; 'under': 0.40; 'best': 0.60; 'url:p': 0.63; 'received:websitewelcome.com': 0.67; 'features:': 0.73; 'research,': 0.82; 'mxodbc': 0.84; 'subject:SQL': 0.84; 'vista,': 0.84; 'xp,': 0.84; '2008.': 0.91; 'light,': 0.91; 'only).': 0.91 Date: Fri, 17 Jun 2011 08:34:44 -0700 From: Ethan Furman User-Agent: Thunderbird 1.5.0.10 (Windows/20070221) MIME-Version: 1.0 To: python@bdurham.com Subject: Re: SQL Server 2008R2 databases via Python 2.7 and Windows XP and higher References: <1308322914.28544.1464263609@webmail.messagingengine.com> In-Reply-To: <1308322914.28544.1464263609@webmail.messagingengine.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - gator410.hostgator.com X-AntiAbuse: Original Domain - python.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - stoneleaf.us X-BWhitelist: no X-Source: X-Source-Args: X-Source-Dir: X-Source-Sender: mail.admailinc.com ([192.168.10.136]) [72.11.125.166]:4000 X-Source-Auth: ethan+stoneleaf.us X-Email-Count: 1 X-Source-Cap: dG9idWs7dG9idWs7Z2F0b3I0MTAuaG9zdGdhdG9yLmNvbQ== Cc: python-list@python.org X-BeenThere: python-list@python.org X-Mailman-Version: 2.1.12 Precedence: list List-Id: General discussion list for the Python programming language List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Newsgroups: comp.lang.python Message-ID: Lines: 22 NNTP-Posting-Host: 82.94.164.166 X-Trace: 1308324067 news.xs4all.nl 49175 [::ffff:82.94.164.166]:55958 X-Complaints-To: abuse@xs4all.nl Xref: x330-a1.tempe.blueboxinc.net comp.lang.python:7827 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~