AnsweredAssumed Answered

Workflow Error when connecting with a database

Question asked by lily on Oct 19, 2017
Latest reply on Nov 2, 2017 by lily

Hello,

 

I am trying to connect to our database from a Nintex 365 form, however, I am getting an error.(workflow-error.png)

 

My workflow looks like the following.(workflow.png)

 

Build String:

INSERT INTO XX.dbo.My_Table

     (ID

      ,Status

      ,Year

      ,Region

      ,Market

     ,Created

      ,Created_By

      )

 

Values

('{Current Item:Region}_{Current Item:Market}',

'Active',

'{Current Item:Year}','

{Current Item:Region}','

{Current Item:Market}','

{Current Item:Created}','

{Current Item:Created By}');

 

 

Connection string:   Server=11.11.111.1,1433;Database=XX;User Id=xxnintex_user;Password=xxxxxxx;

 

Thank you so much for your help.  Please let me know if you any more questions.

Attachments

Outcomes