[Tutor] MS SQL Connection

[Kent Johnson]

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

> 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
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Tutor maillist  -  Tutor at python.org
> http://mail.python.org/mailman/listinfo/tutor