Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

(Sorry for the awful title, but I will refine if we can figure this out...)

I've imported data through drag 'n drop without using the geometry_columns name specifically - the default name when importing via this method is "qgs_geometry".

However, when I try to drag in another layer, I get the following error:

enter image description here

There is indeed a gdb.geometry_columns table in my database already (which is odd, because the table name of the spatial table I imported is *dbo.*tableName (rather than gdb, which is the user I am connecting through...)

So for kicks, I deleted the geometry_columns table, and now I get this error:

enter image description here

I think i'll stop deleting tables for now.

Any idea what this means?

Thanks!

-m

share|improve this question
1  
I think the tables (geometry_columns and spatial_ref) normally are supposed to be in PostGIS. I doubt that SQL Server requires these columns when working with spatial data –  Peter Horsbøll Møller Jul 29 '13 at 6:58
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.