[Tutor] MS SQL Connection

[Martin Walsh]

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
> http://adodbapi.sourceforge.net/
> 
> Kent

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.

http://python-sybase.sourceforge.net/

Good luck!
Marty

> 
>> 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.
>>
>> http://pymssql.sourceforge.net/
>>
>> Mike
>>