0 Replies Latest reply: Jul 8, 2010 10:30 AM by Chris Whitlock RSS

    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?