Setting the SQL connection string on a Finish action in Intelligent Forms
Issue
You can set the SQ: connection string in the Finish action when calling a custom stored procedure, but if the Intelligent Form is imported into a different environment, it will call the stored procedure from the server on the original environment.
Solution
To avoid this issue, omit the SQL connection string. When there is no value for the SQL connection string, SmartIQ obtains the connection string from Infiniti Manage instead.
You can set the connetion string in Infiniti Manage > Settings > SQL Server.
NOTE: The SQL connection string is encrypted and normally is set by the hosting team.
If you are on an on-premise environment then use the following connection string and change the server and credentials.
server=YOURSERVER;database=Changepoint;uid=USERID;pwd=PASSWORD;trusted_connection=No;TimeOut=300