Bug report #14465

Styling of Microsoft SQL data not working

Added by Arnold Huisman almost 8 years ago. Updated almost 8 years ago.

Category:Data Provider/MSSQL
Affected QGIS version:2.14.0 Regression?:No
Operating System:Windows Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:22443


Styling of data coming from Microsoft SQL Server does not work. When applying a style that is dependant on data, for example setting a categorized or rule dependant fill or labelling, the only thing that is rendered is the default color or label. Using the same exact style (via copy and paste) on the postgre or shapefile works correctly. The styling also worked in 2.8.7 ltr. Looks like a bug in the MS-SQL driver or render engine.

I have doen the follwoing to reproduce the error:
- Create a table with a geometry column and a nvarchar(50) column as identifier (for categorized style or labelling)
- Add this table as a layer in QGIS
- Apply a label render with the label being the nvarchar column. The text is not rendered on the map.
- Apply a categorized or rule based style with the nvarchar column, only the default is rendered. The column does not seem to be evaluted.
- This applies to all kinds of geometry, points, lines and polygons.
- Using the same style on exactly the same table in postgre or as a shapefile works correctly.

Related issues

Duplicates QGIS Application - Bug report #14402: Labels and MSSQL layers Closed 2016-03-02


#1 Updated by Anita Graser almost 8 years ago

  • Operating System changed from Windows + MSSQL to Windows
  • Category set to Data Provider/MSSQL

#2 Updated by Anita Graser almost 8 years ago

Probably a duplicate of #14402

#3 Updated by Arnold Huisman almost 8 years ago

  • % Done changed from 0 to 100
  • Target version set to Version 2.14
  • Status changed from Open to Closed

I looked at the other bug and it is the same behavior, so it is solved already. I will test it when a new release of QGIS 2.14 is done.

Also available in: Atom PDF