0 Replies Latest reply: Jan 2, 2014 11:41 AM by Giorgia Michieli RSS

    Timeout while connecting to MySQL

    Giorgia Michieli

      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!