ODBC - Get Collection - command timeout. Is it possible to extend?

[DavidWood]

​​Hello all!

I'm using ODBC Object Get Collection to run a complex SQL and return the results as a Collection in BP.

The query is taking approx. 45 seconds to run, and so is timing out every time I run it in BP. Is it possible to extend this to say, 1 minute? I've looked everywhere but couldn't find a solution!

Cheers!

[John__Carter]

I think the default is 30 seconds a tweak to the code stage is required. Find the line where the odbcCommand object is created and add a line after it to set the CommandTimeout property. For example:

oCommand = New System.Data.odbc.odbcCommand
oCommand.CommandTimeout = 60