Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to detect ADO CommandTimeout
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
How to detect ADO CommandTimeout
Miscellaneous
Thread ID:
00469628
Message ID:
00469628
Views:
56
I am using the CommandTimeout property on an ADO connection in Visual Basic to prevent queries to my FoxPro tables from running too long. This seems to work, but I need a way to determine whether a query ran to completion or timed out. I tried using the ADO event ExecuteComplete, but adStatus is always adStatusOk. I also tried running the query asynchronously (see MS knowbase article Q190606), but I get the error Current provider does not support asynchronous execution. Does anyone have an idea or a work around?

Thanks!
Next
Reply
Map
View

Click here to load this message in the networking platform