I am connecting to a Mysql Database from my local computer. I have already created an ODBC with is working (the connection test is successfull in QV).
Now in the QV script editor , i am loading some table from the database. QV loads all the tables but "close" button is not activated (see picture attached). It is like qlikview is hanging, and i don't know the reason .
Can someone help me to find out what could be the reason of this behaviour ?
I am not still sure that if you are hanging on to this problem. I guess Actual problem is due that there are still some table needs to be fetched. but your due to time lags in query, odbc is sending queries again and again which is causing a lot of load on database server. Its not only hanging your system but also database program you are using.
If you have found any solution to this I would appreciate if you can share.
If Unit table is the last table you are fetching then, Qlikview is linking the tables. So if you have more than 1 field common between two or more table, it will create the syn table and thus it is taking time.
If Unit table is not the last table in your script then, qlikview is waiting for your database to reply the data set.