cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling MSSQL Stored procedure

ppradhan-2
Newbie

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 1

Re: Calling MSSQL Stored procedure

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

Tags (2)
Announcements

Check out the upcoming Expert Session: Understanding ThingWorx Navigate Licensing in Community "Customer Events" section.