[QGIS-Developer] MSSQL Spatial vector features not showing up in QGIS 2.18 up

Diego Sartori gisdsh at gmail.com
Thu Oct 26 06:40:17 PDT 2017


The MSSQL table has a int primary key (unique, no nulls), and a geography
colmumn. The question is ¿why it works OK in 2.14 and doesn't work in 2.18
and 2.99 with the same setup?
I have some screenshots but I don't know how to post them.

On Thu, Oct 26, 2017 at 9:16 AM, Diego Sartori <gisdsh at gmail.com> wrote:

> Sorry Nathan, I've sent the email back to you. I dont't know how to use
> the mailing list.
> Should I send the mail back it to QGIS-Developer at lists.osgeo.org ?
> Hoy do I continue with the thread ?
>
> On Thu, Oct 26, 2017 at 9:10 AM, Diego Sartori <gisdsh at gmail.com> wrote:
>
>> The MSSQL table has a int primary key (unique, no nulls), and a geography
>> colmumn. The question is ¿why it works OK in 2.14 and doesn't work in 2.18
>> and 2.99 with the same setup?
>> I have some screenshots but I don't know how to post them.
>>
>> On Thu, Oct 26, 2017 at 8:54 AM, Nathan Woodrow <madmanwoo at gmail.com>
>> wrote:
>>
>>> You need to have a unique int based column QGIS can use as a row id at
>>> the moment.  That might be why.
>>>
>>> On Thu, Oct 26, 2017 at 9:40 PM, Diego Sartori <gisdsh at gmail.com> wrote:
>>>
>>>> I'm importing a MSSQL 2008 Spatial layer in QGIS. In version 2.14 it
>>>> works OK, I can see the vector features and interact with the associated
>>>> attribute tables. But in versions 2.18 and 2.99, though the connection is
>>>> OK (I can see the attribute tables), the features are not showing up in the
>>>> map canvas. I can even modify the data in the tables but I can't
>>>> graphically select the features for editing.
>>>> I'm using a Windows 10 PC. The 3 versions of QGIS are runnig in the
>>>> same machine, at the same time, with the same configuration. I've tried
>>>> with the standalone installer and with the OSGEO4W installer (32 bit).
>>>> ¿Anything changed from version 2.14 to newer versions that I can't get
>>>> the features drawn on the map in version 2.18.13 and 2.99.0?
>>>> This is my first post here and I'd like to add some screen captures,
>>>> ¿how should I poceed?
>>>>
>>>> _______________________________________________
>>>> QGIS-Developer mailing list
>>>> QGIS-Developer at lists.osgeo.org
>>>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>>>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>>>>
>>>
>>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20171026/dc5bafe2/attachment.html>


More information about the QGIS-Developer mailing list