[Qgis-user] Version 2.2 Valmiera with SQL Server

[Bernard BISconsult]

Dear Nathan

 

Thank you, this was the ultimate tip. Now it works in 2.2.

 

Emile

 

Von: Nathan Woodrow [mailto:madmanwoo at gmail.com] 
Gesendet: Sonntag, 28. Dezember 2014 12:53
An: Bernard BISconsult; qgis-user at lists.osgeo.org
Betreff: Re: [Qgis-user] Version 2.2 Valmiera with SQL Server

 

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/> Das Bild wurde vom Absender entfernt.

Diese E-Mail wurde von Avast Antivirus-Software auf Viren geprüft. 
www.avast.com <http://www.avast.com/>  

 

_______________________________________________
Qgis-user mailing list
Qgis-user at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user



---
Diese E-Mail wurde von Avast Antivirus-Software auf Viren geprüft.
http://www.avast.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20141228/d88c5a42/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ~WRD000.jpg
Type: image/jpeg
Size: 823 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20141228/d88c5a42/attachment.jpg>