Bug report #11094

Loading simple SQL-Server table not possible

Added by Filip Mahieu about 7 years ago. Updated about 7 years ago.

Status:Closed
Priority:Normal
Assignee:-
Category:Data Provider/MSSQL
Affected QGIS version:2.4.0 Regression?:No
Operating System:XP Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:19427

Description

When trying to add certain simple SQL Server-tables in 2.4, like one as added file, QGis tells me it is an invalid layer.
In 2.2 this is not a problem.

TblGWP.sql - SQL-Create-script table (276 Bytes) Filip Mahieu, 2014-08-25 02:07 AM

History

#1 Updated by Nathan Woodrow about 7 years ago

  • Status changed from Open to Feedback

Is GWP unique?

Make sure it is, or at least add a int primary key column with IDENTITY. QGIS 2.4 requires there to be a unique column it can use as a key. In 2.2 this wasn't enforced but caused issues inside QGIS so I made it enforce in 2.4.
re

#2 Updated by Filip Mahieu about 7 years ago

  • % Done changed from 0 to 100
  • Status changed from Feedback to Closed

Ok, this seems to solve the issue.

Thanx!

Also available in: Atom PDF