Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

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

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

0 Replies