I am not sure about ODBC time out, I always use the native ADO providers - more efficient, but be aware the ADO connection and command objects also have a timeout setting. Maybe one of these, in your case, the connection is timing out and the error message is not correct.
'-set the connection timeout
strcon.CommandTimeOut = 500 '- this is seconds
instead of the default of 30 seconds