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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Leon Keylin Sent: Monday, May 21, 2007 3:52 PM To: tutor@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
_______________________________________________ Tutor maillist - Tutor@python.org http://mail.python.org/mailman/listinfo/tutor