Changes for page How to enable encryption
Last modified by Gideon Lombard on 2021/08/12 10:55
Change comment:
There is no comment for this version
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -32,7 +32,6 @@ 32 32 1. Click the **Generate STP File** and save the STP file again 33 33 [[image:1623328525432-818.png]] 34 34 35 - 36 36 == Database Settings == 37 37 38 38 ... ... @@ -39,20 +39,18 @@ 39 39 === Parent Service === 40 40 41 41 {{code language="SQL"}} 42 -UPDATE tblBatchParent SET txtConnStr Schedule= REPLACE(txtConnStrSchedule, ';Password=', ';Encrypt=true;Password=')43 -WHERE txtConnStr ScheduleNOT LIKE '%Encrypt%'41 +UPDATE tblBatchParent SET txtConnStr = REPLACE(txtConnStr, ';Password=', ';Encrypt=true;Password=') 42 +WHERE txtConnStr NOT LIKE '%Encrypt%' 44 44 45 45 UPDATE tblBatchParent SET txtDocConnStr = REPLACE(txtDocConnStr, ';Password=', ';Encrypt=true;Password=') 46 46 WHERE txtDocConnStr NOT LIKE '%Encrypt%' 47 47 48 -UPDATE tblBatchParent SET txtConnStrSchedule = REPLACE(txt DocConnStr, ';Password=', ';Encrypt=true;Password=')47 +UPDATE tblBatchParent SET txtConnStrSchedule = REPLACE(txtConnStrSchedule, ';Password=', ';Encrypt=true;Password=') 49 49 WHERE txtConnStrSchedule NOT LIKE '%Encrypt%' 50 50 51 -UPDATE tblBatchParent_Schedule SET txtConnStrProcess = REPLACE(txt DocConnStr, ';Password=', ';Encrypt=true;Password=')50 +UPDATE tblBatchParent_Schedule SET txtConnStrProcess = REPLACE(txtConnStrProcess, ';Password=', ';Encrypt=true;Password=') 52 52 WHERE txtConnStrProcess NOT LIKE '%Encrypt%' 53 53 54 -UPDATE tblBatchParent_Schedule SET txtDocConnStrProcess = REPLACE(txtDocConnStr, ';Password=', ';Encrypt=true;Password=') 53 +UPDATE tblBatchParent_Schedule SET txtDocConnStrProcess = REPLACE(txtDocConnStrProcess, ';Password=', ';Encrypt=true;Password=') 55 55 WHERE txtDocConnStrProcess NOT LIKE '%Encrypt%' 56 - 57 - 58 58 {{/code}}