Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.python > #7827
| 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 | <ethan@stoneleaf.us> |
| 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 <ethan@stoneleaf.us> |
| 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 <python-list.python.org> |
| List-Unsubscribe | <http://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe> |
| List-Archive | <http://mail.python.org/pipermail/python-list> |
| List-Post | <mailto:python-list@python.org> |
| List-Help | <mailto:python-list-request@python.org?subject=help> |
| List-Subscribe | <http://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe> |
| Newsgroups | comp.lang.python |
| Message-ID | <mailman.75.1308324067.1164.python-list@python.org> (permalink) |
| 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 |
Show key headers only | 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
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