In QGIS (2.8) I am trying to add non-geometric data / flat data that originates in a MS SQL database. This flat data later should be joined with other layers etc.
Connecting to the specific database = working Listing the table that I would like to open up in QGIS = working
When adding the selected 'flat' table I get the following error message:
dbname='data' host=server\sql2008 table="dbo"."TABLE" sql= is an invalid layer - not loaded
Is there a "trick" or a set of conditions that the table needs to meet before it can be added into QGIS as "flat" data?