I have several queries that take upwards of a minute and thirty seconds to run. There doesn't seem to be any place to set the query timeout when running queries.
Is there? I've downloaded the source, but I'd rather just change a config setting if it's available.
Thanks!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have learned that there is no option to change the query command timeout. I actually downloaded the Microsoft C# Visual Studio Express, updated the .CommandTimeout values in the DataManager and OdbcDataManager files (under the Sql2000 directory), but no dice. Still stops at a minute with a server timeout error. Any suggestions for running long queries?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have several queries that take upwards of a minute and thirty seconds to run. There doesn't seem to be any place to set the query timeout when running queries.
Is there? I've downloaded the source, but I'd rather just change a config setting if it's available.
Thanks!
I have learned that there is no option to change the query command timeout. I actually downloaded the Microsoft C# Visual Studio Express, updated the .CommandTimeout values in the DataManager and OdbcDataManager files (under the Sql2000 directory), but no dice. Still stops at a minute with a server timeout error. Any suggestions for running long queries?