0 Replies Latest reply: Nov 17, 2014 10:38 PM by Yeo Poh sai RSS

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

    Yeo Poh sai

      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 .