topic SQL FAILS TO FETCH DATA in QlikView https://community.qlik.com/t5/QlikView/SQL-FAILS-TO-FETCH-DATA/m-p/217734#M714735 <HTML><HEAD></HEAD><BODY><P>Currently have a PC (PC A) logged onto our network which reloads a QVW file every hour.</P><P>The file has the following connection to a SQL Server.</P><P>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];</P><P>The reload works on our individual PCs but has stopped working on the (PC A) machine.</P><P>The QVW connects to the SQL but doesnt download any lines of data, yet running the file on another machine does.!</P><P>Its very puzzling as it suddently stopped working.</P><P>We have tried the following : 1. recreating ODBC connection, Fresh install of QV9, clean registry, permissions on SQL server.</P><P>Anyone any ideas?</P><P></P><P></P></BODY></HTML> Thu, 08 Jul 2010 14:30:33 GMT 2010-07-08T14:30:33Z SQL FAILS TO FETCH DATA https://community.qlik.com/t5/QlikView/SQL-FAILS-TO-FETCH-DATA/m-p/217734#M714735 <HTML><HEAD></HEAD><BODY><P>Currently have a PC (PC A) logged onto our network which reloads a QVW file every hour.</P><P>The file has the following connection to a SQL Server.</P><P>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];</P><P>The reload works on our individual PCs but has stopped working on the (PC A) machine.</P><P>The QVW connects to the SQL but doesnt download any lines of data, yet running the file on another machine does.!</P><P>Its very puzzling as it suddently stopped working.</P><P>We have tried the following : 1. recreating ODBC connection, Fresh install of QV9, clean registry, permissions on SQL server.</P><P>Anyone any ideas?</P><P></P><P></P></BODY></HTML> Thu, 08 Jul 2010 14:30:33 GMT https://community.qlik.com/t5/QlikView/SQL-FAILS-TO-FETCH-DATA/m-p/217734#M714735 2010-07-08T14:30:33Z