Does anyone know how to increase ODBC timeout?...getting this error message when doing "select count(*) c from oa_fkeys"...

Timeout is generally set in the connection string somewhere dependant on what software you are using, it might be a default of 30 secs or something. Usually, a setting of 0 means no timeout.