sql - How to tell if ADODB CommandTimeout is reached?

Question

I have some VBA that queries a SQL database using ADODB. Currently I have the CommandTimeout set to 30 seconds. If nothing is returned, that can either be because no such record exists in the SQL database, or because the timeout was reached. I would like to be able to distinguish these two cases and display a warning when the timeout is reached. Is there a way to achieve this?

Answer 1

Firstly read this: ADO Event Instantiation: Visual Basic

Check EventStatusEnum for adStatusOK - which should not be set in case TimeOut.

You could also catch up "InfoMessage" InfoMessage Event to see information like in SSMS when you run query.