Skip to main content
ppradhan-21-Visitor
1-Visitor
Sep 9, 2017 6:57 AM UTC
Question

Calling MSSQL Stored procedure

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

bdeshmukh1-Visitor
1-Visitor
Jun 27, 2018 7:13 AM UTC

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

Translate
Terms & ConditionsAccessibility statement