Summary

• Page properties (1 modified, 0 added, 0 removed)

Details

Page properties

Content

...	...	@@ -32,6 +32,7 @@
32	32	1. Click the **Generate STP File**  and save the STP file again
33	33	[[image:1623328525432-818.png]]
34	34
	35	+
35	35	== Database Settings ==
36	36
37	37
...	...	@@ -38,18 +38,20 @@
38	38	=== Parent Service ===
39	39
40	40	{{code language="SQL"}}
41		-UPDATE tblBatchParent SET txtConnStr = REPLACE(txtConnStr, ';Password=', ';Encrypt=true;Password=')
42		-WHERE txtConnStr NOT LIKE '%Encrypt%'
	42	+UPDATE tblBatchParent SET txtConnStrSchedule = REPLACE(txtConnStrSchedule, ';Password=', ';Encrypt=true;Password=')
	43	+WHERE txtConnStrSchedule NOT LIKE '%Encrypt%'
43	43
44	44	UPDATE tblBatchParent SET txtDocConnStr = REPLACE(txtDocConnStr, ';Password=', ';Encrypt=true;Password=')
45	45	WHERE txtDocConnStr NOT LIKE '%Encrypt%'
46	46
47		-UPDATE tblBatchParent SET txtConnStrSchedule = REPLACE(txtConnStrSchedule, ';Password=', ';Encrypt=true;Password=')
	48	+UPDATE tblBatchParent SET txtConnStrSchedule = REPLACE(txtDocConnStr, ';Password=', ';Encrypt=true;Password=')
48	48	WHERE txtConnStrSchedule NOT LIKE '%Encrypt%'
49	49
50		-UPDATE tblBatchParent_Schedule SET txtConnStrProcess = REPLACE(txtConnStrProcess, ';Password=', ';Encrypt=true;Password=')
	51	+UPDATE tblBatchParent_Schedule SET txtConnStrProcess = REPLACE(txtDocConnStr, ';Password=', ';Encrypt=true;Password=')
51	51	WHERE txtConnStrProcess NOT LIKE '%Encrypt%'
52	52
53		-UPDATE tblBatchParent_Schedule SET txtDocConnStrProcess = REPLACE(txtDocConnStrProcess, ';Password=', ';Encrypt=true;Password=')
	54	+UPDATE tblBatchParent_Schedule SET txtDocConnStrProcess = REPLACE(txtDocConnStr, ';Password=', ';Encrypt=true;Password=')
54	54	WHERE txtDocConnStrProcess NOT LIKE '%Encrypt%'
	56	+
	57	+
55	55	{{/code}}