On Tuesday 22 May 2007 06:35, Leon Keylin wrote: > Hi John, > > Here's the code (I do have permissions to truncate, works manually under > the same user. > > > import pymssql > > con = pymssql.connect > (host='server',user='user',password='pwd',database='DB_QA') > cur = con.cursor() > > > query="truncate TABLE bbConsolidatedMessageAcks" > cur.execute(query) > print "Deleted Records: %d" % cur.rowcount > I see from the other postings that you are running windows. I am on SUSE 10.2 using FreeTDS and pymssql. In my case my "cur.execute" is passed to FreeTDS and FreeTDS is what really interfaces with the SQL server. I'm also running a patch from www.dabodev.com but I doubt that would stop you from passing the truncate.
Are you using pymssql-0.8.0.win32-py2.5.exe and ODBC ? Can you see the trace provided by MS SQL? -- John Fabiani _______________________________________________ Tutor maillist - [email protected] http://mail.python.org/mailman/listinfo/tutor
