Discussion Board for collaboration related to QlikView Deployment.
I'm using 'Microsoft OLE DB Provider for Visual FoxPro 9.0' driver to read FoxPro database files.
OLEDB CONNECT32 TO [Provider=MSDASQL.1;Persist Security Info=False;Data Source=Visual FoxPro Tables;Extended Properties="DSN=Visual FoxPro Tables;UID=;SourceDB=$(file);SourceType=DBC;Exclusive=No;BackgroundFetch=Yes;Null=Yes;Deleted=Yes;"];
If i perform the reload using the Qlikview Desktop, it works without a problem. and fast too.
If i try to run the same .qvw in the QMC, the task hangs!
My first thought was that it has to do with the credentials of the account which executing the file. However, both me and the QDS account share exectly the same permissions.
I'm getting pretty desperate here. please help...
Qlikview 11 SR2
Go to Solution.
It turned out to be a driver problem. The ADO.NET driver for FoxPro stored .tmp file in the %TEMP% directory every it encountered a "heavy" table. clearing the cache solved the problem.
Is the DSN setup as a "USER" or "System". This is the only thing I can think of.
You should configure the DSN as "System" DSN to make connectivity with database.