Summary

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

Details

Page properties

Content

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