How to change pymssql timeout value?

S

saqib

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,743
Messages
2,569,478
Members
44,898
Latest member
BlairH7607

Latest Threads

Top