[Tutor] MS SQL Connection
mwalsh at groktech.org
Tue May 22 05:33:12 CEST 2007
Kent Johnson wrote:
> Leon Keylin wrote:
>> Thanks Mike, unfortunately that's the mod I had problems with before.
>> The one that
>> can't do truncate. I've written about it before here and it was easier
>> to look for
>> another solution.
> You could try adodbapi
Could be a long shot -- but you might also have a look at python-sybase.
A few years ago I used Sybase (with freetds) to access ms sql server
2000 from linux -- which I found very satisfying. However, I suspect
adodbapi is a lot easier to install on a windows system.
>> Is there any other way? Should I be looking for a different language to
>> do it in?
>> > -----Original Message-----
>> > From: tutor-bounces at python.org <mailto:tutor-bounces at python.org>
>> > [mailto: tutor-bounces at python.org <mailto:tutor-bounces at python.org>]
>> On Behalf Of Leon Keylin
>> > Sent: Monday, May 21, 2007 3:52 PM
>> > To: tutor at python.org <mailto:tutor at python.org>
>> > Subject: [Tutor] MS SQL Connection
>> > Been trying to do a very small and simple select via Python.
>> > First I tried a module that looked clean but it couldn't
>> > truncate tables.
>> > Then I started sifting through docs at python.org
>> <http://python.org/> and
>> > couldn't find a simple
>> > way of communicating with a MS SQL via Python program.
>> > Do I have to use ODBC?
>> > Any examples would be awesome. Thanks!
>> I did a quick search on Google for MS SQL Python, and this came up. It
>> looks like it will do the trick.
More information about the Tutor