Article - CS413415
Error "The statement did not return a result set" is returned on some ThingWorx server when executing service on a DatabaseThing to Microsoft SQLServer
Modified: 15-Mar-2024
Applies To
- ThingWorx Platform 9.1 to 9.5
Description
- Following error is received when executing a SQL service on some servers
com.microsoft.sqlserver.jdbc.SQLServerException: The statement did not return a result set.
- Difference in behavior between production server and local installation of ThingWorx
- SQL queries executed via sp_prepexec in local installation and via sp_executesql in production server
- Same SQL server and configuration used in both installations
This is a printer-friendly version of Article 413415 and may be out of date. For the latest version click CS413415