I have a query running through ODBC driver. I got timeout message.
ODBC - Call failed.
[IBM][iSeries Access ODBC Driver]SQL0666-SQL query exceed specified time limit
[IBM][iSeries Access ODBC Driver]Extended dynamic support disabled.
I have run this query directly on AS400 with no problem.

I have searched the solution:
IBM - ODBC Query Timeout Property: SQL0666 Estimated Query Processing Time Exceeds Limit

I have tried set up odbc.ini
cwbODBCreg myDSN QueryTimeout 0

I have also wrote this on my VBA code.
cmd.CommandTimeout = 0


But still didn't work.


Please help.

Thanks,

Lisa