[Tutor] MS SQL Connection

[johnf]

On Monday 21 May 2007 16:21, 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.
>
> 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
Mike I just tried it and it worked using pymssql-0.8.0.   Could you post the 
code you are using to truncate?  Also is it possible you don't have 
permission to truncate?
-- 
John Fabiani