Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!selfless.tophat.at!newsfeed.xs4all.nl!newsfeed5.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail
Return-Path: <mail@timgolden.me.uk>
X-Original-To: python-list@python.org
Delivered-To: python-list@mail.python.org
X-Spam-Status: OK 0.006
X-Spam-Evidence: '*H*': 0.99; '*S*': 0.00; '2.7': 0.04; 'subject:Python': 0.06; 'python': 0.08; 'from:addr:timgolden.me.uk': 0.09; 'from:name:tim golden': 0.09; 'message-id:@timgolden.me.uk': 0.09; 'pyodbc': 0.09; 'subject:2.7': 0.09; 'wrote:': 0.14; '1.02': 0.16; 'mixture': 0.16; 'received:74.55.86': 0.16; 'received:74.55.86.74': 0.16; 'received:smtp.webfaction.com': 0.16; 'received:webfaction.com': 0.16; 'subject: \n ': 0.16; 'years)': 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; '(and': 0.25; 'windows': 0.26; 'server': 0.29; 'cc:addr:python.org': 0.30; 'tjg': 0.30; '2005': 0.31; 'url:products': 0.31; 'done': 0.32; 'list': 0.33; "i've": 0.33; 'all.': 0.35; 'header:User-Agent:1': 0.35; 'problems': 0.36; 'running': 0.37; 'platforms': 0.37; 'pretty': 0.37; 'two': 0.37; 'url:python': 0.38; 'subject:: ': 0.38; 'some': 0.38; 'url:google': 0.38; 'received:192': 0.38; 'under': 0.40; 'best': 0.60; 'url:p': 0.63; 'from:addr:mail': 0.65; 'research,': 0.82; 'mxodbc': 0.84; 'subject:SQL': 0.84; 'vista,': 0.84; 'xp,': 0.84; '2008.': 0.91; 'to:none': 0.93
Date: Fri, 17 Jun 2011 16:13:57 +0100
From: Tim Golden <mail@timgolden.me.uk>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-GB; rv:1.9.2.17) Gecko/20110414 Lightning/1.0b2 Thunderbird/3.1.10
MIME-Version: 1.0
CC: python-list@python.org
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-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.74.1308323717.1164.python-list@python.org>
Lines: 18
NNTP-Posting-Host: 82.94.164.166
X-Trace: 1308323717 news.xs4all.nl 49178 [::ffff:82.94.164.166]:60679
X-Complaints-To: abuse@xs4all.nl
Xref: x330-a1.tempe.blueboxinc.net comp.lang.python:7826

On 17/06/2011 16:01, 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

I use pyodbc (and have done for some years) without any problems
at all. Barring the one or two issues I've logged which are
being addressed. (grin). We use pretty much exactly the mixture
of platforms you're describing.

TJG