QV Server 10 Reload Problem

[#1]

Hi all,

I've got a problem with the reload task.

My scenario is as follows:

-I have 4 qv source documents.

-Each document has a reload task that is set not to run at the same time as the other 3.

-The query behind the 4 documents all access the same database and table. In fact, it is the exact same query, just with different where clauses.

What is weird is that only 1 of the 4 tasks reload properly and that is the only one that works, regardless of whether it's by the task schedule or by manually running it.

Does anyone have any ideas of why this is occurring?

Thanks in advance.

[#2]

Sorry for the late response. In case you still have this problem, the Provider is in the connection string of the qv document.

[#3]

Sorry for the late response. In case you still have this problem, we solved this problem by switching the Provider in the database connection string of the qvw document. It'll begin with "CONNECT TO [Provider=".