Community Tip - Want the oppurtunity to discuss enhancements to PTC products? Join a working group! X
Hi guys,
I'm trying to run a service that is a SQL query that execute a Stored Procedure from MSSQL.
When I try to execute the query on ThingWorx, I get the following error:
However, when I execute this exactly stored procedure on SQL Management Studio, it works fine and get the following result:
Does anyone know how to solve this?
Thanks,
De Hong
Solved! Go to Solution.
I fixed the problem.
Based on another post here, I just wrote "SET NOCOUNT ON;" in the procedure and it worked!
But Thanks Sushant Pandey!
Hi De Hong, what sort of an sql statement that procedure is executing? I just tested with SQLQuery service with following procedure that requires an input parameter
execute demoproc3 @colname =2
And it works fine. Note procedure contains select statement and returning single column as result
I fixed the problem.
Based on another post here, I just wrote "SET NOCOUNT ON;" in the procedure and it worked!
But Thanks Sushant Pandey!