I know that this question has been asked before but I believe my case is a little different... We do have a geometry columns table as well as a spatial references table in our spatial database, however I still have following error message.

enter image description here

Like I said, we have a geometry table and a spatial references table for QGIS to look at. enter image description here

When I add a new connection, ONLY these newly created feature classes in our database are recognised as spatial data. All the old entries are recognised as non-spatial tables. enter image description here

Following is the details of above two tables in geometry columns table

enter image description here

I am puzzled. Anyone could shed some light please?

  • 1
    Your tables are not native MSSQL spatial tables but they are made with ESRI SDE tools. For reading those with QGIS you should have a GDAL version that has been built with the SDE driver gdal.org/drv_sde.html. – user30184 Jan 12 '18 at 5:52
  • Cheers mate, I have read your link over the weekend, just wondering if you can make it more clear for me please? Does this driver need to be installed on my computer or on the machine that installed ArcSDE ? Do you have a procedure to follow? Many thanks again!! – Julian_Y Jan 15 '18 at 8:19
  • You should have the SDE driver on your computer. For installing it you need some libraries from ESRI and I have been reading that it may be tricky to compile the driver. – user30184 Jan 15 '18 at 9:05
  • Thanks for your help...though I am still puzzled....I searched this forum and found few posts regarding to ArcSDE driver, not sure if ArcSDE 10.2.2 is supported? And a number of links to download important .dll are leading to 404 errors.... – Julian_Y Jan 19 '18 at 7:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.