I made a successful connection to a local MSSQL Database where there are no spatial tables (only datatables).

I list the tables/views in the database (clicking on "Also list tables with no geometry" checkbox).

Some tables add to my workspace but I can only see one record for each table. This is the case with 75% of table/views. In table view it says it is filtered but I see no visible filter in layer properties. Besides, it always shows just the last record of the table/view.

Some other tables can't be loaded (although they have primary key in SQL Server) and I only get "It's not a valid layer" mesage.

The result is that I can't load any table from MSSQL properly...

enter image description here

I am in QGIS 3.2.2

  • I discovered that the table/view needs to have an ID count (integer) field. Add that (does not need to be primary key) and now it works as supposed. – Egidi Sep 6 '18 at 12:06

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.