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

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:20': 0.22; 'cc:no real name:20': 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> (permalink)
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

Show key headers only | View raw

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

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 Tim Golden <mail@timgolden.me.uk> - 2011-06-17 16:13 +0100

csiph-web