Connection to a remote DB: Load hanging

[#1]

hi all,

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 ?

Best Regards

Cherif

[adnan_rafiq]

Thanks every one.

If you read my comment and related problem. I have narrowed down the

issue,

Let me clarify issue again. When Qlikview sends sql query to database, for

large table it take a lot of time to execute, mean while qlikview keep on

sending same query again and again. this cause system load to increase and

hang database or database closes all connection forcefully to avoid

database downtime.

Can you help me to make sure Qlikview don't send any other command until

the first one is returned.

and Kaushik, I am droping them as soon as data is fetched so, I am clear

about issue, when I fetch relatively small table issue don't arise. and my

database admin still tells me that its creating multiple queries on same

table

Regards