Difference between timeouts in DAO & ADO.NET RRS feed

  • Question

  • Could any one share the difference between the property "ODBCCommand.CommandTimeout" in ADO.NET and the property "QueryDef.ODBCTimeout".

    As per my inference, on setting the value of ODBC timeout in DAO, the query execution stops if it exceeds the value set. But in ADO.NET i cannot find any such equivalent properties in ODBCConnection object.

    If we set the property "CommandTimeout" in ADO.NET (ODBCCommand)it doesnt mean the same as that in DAO. If we set it to say "x", then it means that it will wait for that particular duration ("x" in this case) before starting the execution. Isnt there any property in ADO.NET (ODBC) which can terminate any database execution if it exceeds a particaular amount of duration?

    Thanks in advance! 

    • Moved by VMazur Wednesday, August 17, 2011 10:09 PM (From:ADO.NET DataSet)
    Tuesday, August 9, 2011 7:45 AM