ThinkGeo.com    |     Documentation    |     Premium Support

Problem with SqlServerFeatureLayer and Sql Views in .net 8

Hello,

I have a problem connecting to an MSSQL view with SqlServerFeatureLayer . We are using ThinkGeo Version 14.2.1 and Microsoft.SqlServer.Types 16 because of .NET Core.

When I try to open/connect, an error occurs: “There is already an open DataReader associated with this Command which must be closed first.”

Changing the table name from a view to a existing table, there is no error anymore. There is no difference between views with a geometry column or without. I also tried to set a non-existing view name like ‘schubidu’ and the same error occurs. It seems like the SqlServerFeatureLayer can’t find the views.

Regards, Torsten

Hi Torsten,

Thanks for letting us know! This issue has been fixed in the latest beta 14.3.0-beta050, and we are planning to have a new release 14.2.2 with all this fix. Sorry for the inconvenience.

Thanks,
Ben