Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

SQL FAILS TO FETCH DATA

Currently have a PC (PC A) logged onto our network which reloads a QVW file every hour.

The file has the following connection to a SQL Server.

CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=XXX_MSCRM;Data Source=XXX-CRM;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=;Use Encryption for Data=False;Tag with column collation when possible=False];

The reload works on our individual PCs but has stopped working on the (PC A) machine.

The QVW connects to the SQL but doesnt download any lines of data, yet running the file on another machine does.!

Its very puzzling as it suddently stopped working.

We have tried the following : 1. recreating ODBC connection, Fresh install of QV9, clean registry, permissions on SQL server.

Anyone any ideas?