topic Re: problem auto reload QV script in QlikView

problem auto reload QV script

Thu, 15 Nov 2012 09:22:31 GMT

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.

Re: problem auto reload QV script

jvitantonio — Thu, 15 Nov 2012 10:43:42 GMT

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.-

Re: problem auto reload QV script

Thu, 15 Nov 2012 11:06:13 GMT

i used CONNECT64 show "Unknown staement".

(in QV version 😎

T T

Re: problem auto reload QV script

jvitantonio — Thu, 15 Nov 2012 11:24:16 GMT

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...

Re: problem auto reload QV script

jvitantonio — Thu, 15 Nov 2012 11:28:53 GMT

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.

Re: problem auto reload QV script

Anonymous — Thu, 15 Nov 2012 15:19:56 GMT

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

Re: problem auto reload QV script

magavi_framsteg — Tue, 15 Apr 2014 11:54:17 GMT

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.