Security OLEDB

corentinjezequel — Thu, 18 Apr 2019 07:24:00 GMT

Hi everyone,

I have an OLEDB connection "

OLEDB CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=$(vCatalogue);Data Source=$(vData_Source);Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=W5FRVFLC0021;Use Encryption for Data=False;Tag with column collation when possible=False];"

And people ask me to turn to true the value of "Use Encryption for Data". I think that it's not possible with "Integrated Security".

Is it more secure to use SSPI with "Use Encryption for Data=False" or to use a security with User Id / XPassword and "Use Encryption for Data=True" ? Or maybe it's the same ?

Thanks & Regards,

Corentin

topic Security OLEDB in QlikView

Security OLEDB