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 ?
