Why is FME imported data into SQL Server not being found by QGIS?
I've imported some MapInfo format data into SQL Server 2014 using FME.
In SQL Management Studio (SSMS), I can do a query and the spatial results tab shows the various polygons as expected
But if I switch to QGIS, create a connection to the database, and then open the list of tables in the dbo schema, the data set isn't showing
I have also loaded data using ogr2ogr and those data sets are showing, and can be displayed on a map in both QGIS and SSMS
So why aren't FME loaded data sets showing?
I deleted the old MSSQL connection, and when I created a new one, I noticed the the "Only look in the geometry_columns metadata table" and "Also list tables with no geometry" options. Unchecked first and checked the second, and now all the tables are showing, both the ones loaded using ogr2ogr and using FME.
Now when I try and add a FME layer, I get the error ...
"Layer is not valid: The layer dbname='GisData' host=(local) user='localdev' password='password' estimatedmetadata=true srid=27700 type=LineString table="dbo"."FmeFootpaths" (GEOM) sql= is not a valid layer and can not be added to the map"
The thing that caught my eye was the srid=27700 ... the ogr2ogr has srid 32768 (Should point out I don't understand srid's?)
Also I checked this geometry_columns, and it only has the tables loaded using ogr2ogr