Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
gjamila_esq
Contributor

Timeout while connecting to MySQL

Hi everybody,

I have several big tables in mysql data base.

When I try to read those tables, qlikview gives me this error:

Error: File extdata.cpp, Line 2787

To understand why, I limited rows:

SQL SELECT *

  FROM database.table limit 500;

and it works!

So I think the problem is a time-out.

How can I set timeout in a mysql connection? It's possible to set it in the expression "ODBC CONNECT TO..."?

Has anyone had this error? How can I fix it?

Thanks a lot!