How to change pymssql timeout value?

saqib at saqibali.org saqib at saqibali.org
Mon Aug 8 01:28:46 EDT 2005



I have a query that is running on a mssql DB that takes about 15
minutes when run "directly"; IE: thru MS SQL Query Analyzer. I know, it
sucks. I'm trying to fix it.

But in the meantime, I have a python process which connects to the DB
using pymssql. This process runs the aformentioned query... but fails
because the query times out after approx 30 seconds. Is there anyway to
change/set the timeout setting on a pymssql DB connection?? I poked
around a bit in the pymssql module but nothing was obvious to me.....

-Saqib




More information about the Python-list mailing list