Morning,
When I run the following using sql executor using the SQL Server Native client I get back a result.
EXEC [dbo].[SP_API_VALID_SUBSCRIBER]
@modules = N'1,2,3,4,5,6,7,8,9',
@clippolygon = N'POLYGON ((-168.046875 -85.62206859340185,183.515625 -85.62206859340185,183.515625 83.35951133035452,-168.046875 83.35951133035452,-168.046875 -85.62206859340185))';
When I run the same query using the JDBC driver for SQL Server no spatial I get no results back, although the sql execution was successful no results are returned. I have tried with and withougt the 'commit;' at the end of the script and this has no effect.
Does anyone have any ideas why this might be?
Many Thanks,
Oliver