Skip to main content
Language Selector

  1. Other Languages

    (machine translation)

Planview Customer Success Center

Setting the SQL connection string on a Finish action in Intelligent Forms

  1. Last updated
  2. Save as PDF

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