[Qgis-user] Version 2.2 Valmiera with SQL Server

[Nathan Woodrow]

Hey,

Do you have a primary key (int based) on those tables?

- Nathan

On Sun Dec 28 2014 at 9:44:23 PM Bernard BISconsult <
emile.bernard at bisconsult.ch> wrote:

> Hello friends
>
>
>
> I'm using QGIS 2.2 Valmiera on a Windows 7 environment with SQL Server
> 2012 holding the data and I'm quite happy about how QGIS displays the data.
> The connection to SQL Servre goes via ODBC. As in my project QGIS is used
> to present data than to create or modify them, I use SQL-Server views as
> the underlying data reference which works fine and fast. However I've got
> one serious problem that is when I use the "Open Attribute Table" on a
> layer it will show the exact number of records, but the record content is
> always the same, probably repeating the content of the first record found
> instead of showing the individual contents (see ccreenshot attached).
>
>
>
> I thought this might be a 2.2 problem meanwhile fixed and installed QGIS
> 2.6 by using the existing .qgs file from 2.2. But after that many layers
> (not all) lost there connection to the SQL Server database and I'm unable
> to connect them. Furthermore using "Open Attribute Table" crashes on layers
> from SQL Server.
>
>
>
> By this mail I hope to get answers on:
>
> 1.       How can I fix the 2.2 problem which displays repeatedly the same
> record when using Open Attribute Table on a layer from SQL Server
>
> 2.       How can I migrate a .qgs mapping from 2.2 to 2.6 which is mainly
> filled with layers on SQL Server data.
>
>
>
> Regards Emile
>
>
>
>
> ------------------------------
>    <http://www.avast.com/>
>
> Diese E-Mail wurde von Avast Antivirus-Software auf Viren geprüft.
> www.avast.com
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20141228/ca5f49e7/attachment.html>