Socketworx is compatible with SQL Server / SQL Server Express 2016 (All Service Packs Recommended/13.x and later Required) through the current version.

Version below 2016 will cause issues with Display and Edit Mode functionality.

Specific Issues include the following functions:

  • JSON Functionality 
    • ISJSON    Tests whether a string contains valid JSON.
    • JSON_VALUE    Extracts a scalar value from a JSON string.
    • JSON_QUERY    Extracts an object or an array from a JSON string.
    • JSON_MODIFY    Updates the value of a property in a JSON string and returns the updated JSON string.

In addition, performance improvements are seen with the latest versions.