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