Run SQL Query - Connection String Error
With the upgrade to Workflow 5.45.1 I am getting an error with a server side workflow using the Run SQL Query. The error indicates it breaks after the User ID text and before the semi colon (where the ^ is in hte example).
"Error: 0: Unexpected Error: VertiGIS.Workflow.Runtime.Execution.Exceptions.ActivityExecutionException: [WF: Activity execution error] Failed to execute activity 16 with action gcx:wf:server::SqlQuery: Format of the initialization string does not conform to specification starting at index 51.",
Example Connection String:
Server xxx;Database=xxx;User Id=xxx^;Password='xxxx',TrustServerCertificate=True;
-
Hi Austin Hildreth. I'm not sure what change would have caused this. What version of Workflow were you on prior to 5.45.1?
0 -
Could it be related to this change?
0 -
Thank you for the responses. After upgrading to version5.45.1 the ‘TrustServerCertificate’ needed to be added to the connection string (we do not have a cert on our DB), however (my mistake) I added the extra parameter with a ‘,’ where a ‘;’ is needed (see above conn string). Simple resolution.
Thanks,
Austin
0
Vous devez vous connecter pour laisser un commentaire.
Commentaires
3 commentaires