I still have problems with query timeouts. I have tried both:

MyDb.dbOptions = "CommandTimeOut=120"
MyDb.dbOptions = "CmdTimeOut=120"

...and still get the following error after appx 30 seconds.

Error # = 80040E31
Description = [Microsoft][ODBC SQL Server Driver]Timeout expired
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = S1T00
NativeError = 0