Skip to main content
P
ppradhan-21-Visitor
1-Visitor
September 9, 2017
Question

Calling MSSQL Stored procedure

  • September 9, 2017
  • 1 reply
  • 1707 views

Hi ,

    I am facing challenge to call stored procedure from Thingworx ->MSSqlThing->services(sql Querry)

it is returning the error shown in attachment.

sql downtime.PNG

error in returning data

sqlerror.PNG

Can anyone pls help on this its kind of urgent

Thanks & Regards

    ​Pravin

1 reply

B
bdeshmukh1-Visitor
1-Visitor
June 27, 2018

Hi Pradhan,

 

Were you able to call the procedure and get the result set from it.

I am getting the exact same error when calling a procedure.
I tried, by using the service handler as both SQL Query and SQL Command.

 

Please let me know if you have any update on this.

 

Thanks and Regards,

Bhushan

Terms & ConditionsCookie settingsAccessibility statement