I am working on a legacy application which uses AspDb. The application is written in classic asp and is running on IIS 6.0. I have a query which is timing out when the user tries to download the CSV file for the entire resultset. I have tried setting the CmdTimeout like this:

MyDb.dbOptions = "CloseConnection=True|CmdTimeOut=360"

But it continues to timeout. I even tried setting CmdTimeOut to 5 and it still doesn't timeout until 30 seconds. I have tried restarting IIS as well as the entire OS and nothing seems to get this to recognize the change. How do I get this to work. This should have only taken me 5 min to fix and now I've wasted a day on it. Please help me.