Calling MSSQL Stored procedure

[ppradhan-2]

Hi ,

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

it is returning the error shown in attachment.

error in returning data

Can anyone pls help on this its kind of urgent

Thanks & Regards

    ​Pravin

[bdeshmukh]

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