0 Replies Latest reply: Nov 17, 2014 10:38 PM by PAUL YEO RSS

    when i reload SQL data it alway ask me enter SQL password ?

    PAUL YEO

      Hi All

       

      I am trying to reload a SQL data into QV , when i press control R. it will pop up a new windows ask me input password of SQL Server login.

       

      My load script as below :-

       

      CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=False;User ID=SA;Initial Catalog=andonDatabas;Data Source=Paul;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=PAUL;Use Encryption for Data=False;Tag with column collation when possible=False];

       

      select * from record_produksi_plc;

       

      where i can add the script for the password = 1 ? so that it will not ask me again .

       

      Paul