problem auto reload QV script

[#1]

Hello,

     I have move windows server 2003 to windows server 2008 r2

old batch scripts don't working.

     see below my script

"C:\Program Files (x86)\QlikView\qv.exe" /r "E:\Qlikview\test.qvw"

I think about connection to oracle

in QV connect by ODBC CONNECT TO XXXX (XUserId is XXXX, XPassword is XXXX);

**but I can reload by ctrl + r

Please help and advice.

[jvitantonio]

Hi, I recommend you use the following connection string:

For a 32bit server:

ODBC CONNECT32 TO XXXX (XUserId is XXXX, XPassword is XXXX);

(note the 32 after CONNECT)

For a 64bit server:

ODBC CONNECT64 TO XXXX (XUserId is XXXX, XPassword is XXXX);

I hope this help.-

[#3]

i used CONNECT64 show "Unknown  staement".

(in QV version 😎

T T

[jvitantonio]

Oh ok, I have no idea about version 8. I work with version 10 or 11. I had this problem before and fix it change the connection string...

[jvitantonio]

Just one more thing. Are you executing the batch file within the same server where you tried to load the qvw file manually? There might be a user right issue.

[Anonymous]

I reckon its because of security permissions to run batch file. How do you run the batch file? Using Windows scheduled tasks?

What if you run it as Administrator?

Regards

MultiView

[magavi_framsteg]

Are you sure QV is installed in "C:\Program Files (x86)\QlikView\qv.exe" and not "C:\Program Files\QlikView\qv.exe"?

Since W2008R2 is a x64 OS, there is no apparent reason to use 32bit QV since x64 QV can use CONNECT32 to use 32bit DB-drivers.

Also, the user account running the batch file must have the local security policy to "Run batch" jobs.