[Tutor] MS SQL Connection

[Leon Keylin]

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.

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] On Behalf Of Leon Keylin
> Sent: Monday, May 21, 2007 3:52 PM
> To: 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 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.python.org/pipermail/tutor/attachments/20070521/e7d170a7/attachment.html