We had a similar experience, and we fixed, almost for the time being, changing some advanced parameters in the Odbc connection.

More specifically, we changed this two parameters:

Performance Tab -> Advanced...