[Qgis-user] MS SQL Server

[Morgan, David]

If you have received this email in error, please notify us by telephone on 01437 764551 and delete it from your computer immediately. Os ydych chi wedi derbyn yr e-bost hwn trwy gamgymeriad, byddwch cystal â rhoi gwybod inni trwy ffonio 01437 764551. Wedyn dylech ddileu’r e-bost ar unwaith oddi ar eich cyfrifiadur.


Mark

Assuming you have a correct entry in your geometry_columns table, you
may also need to add a unique, numeric 'key' column to your database
table. When I have had problems in the past loading SQL Server tables
into QGIS, not having a unique identifier has usually been the problem. 

Dave

Date: Fri, 21 Jun 2013 19:56:51 +0000
From: Mark Paulson <markp at proseals.com>
To: "qgis-user at lists.osgeo.org" <qgis-user at lists.osgeo.org>
Subject: [Qgis-user] MS SQL Server
Message-ID: <CDEA1A31.2FC16%markp at proseals.com>
Content-Type: text/plain; charset="us-ascii"

I have a table in MS SQL Server that was converted from a shape file and
works fine is GeoServer that cause an error when I try to addict to
QGIS. The funny think is that I can add table from my MS SQL server
ArcSDE database. I'm just getting started so please forgive me if this
has been answered previously

Thanks
Mark
*******

**************************************************************************************************************

This document should only be read by those persons to whom it is addressed, and be used by them for its intended purpose; and must not otherwise be reproduced, copied, disseminated, disclosed, modified, distributed, published or actioned. If you have received this email in error, please notify us immediately by telephone on 01437 764551 and delete it from your computer immediately. This email address must not be passed on to any third party nor be used for any other purpose.

Pembrokeshire County Council Website - http://www.pembrokeshire.gov.uk

Please Note: Incoming and outgoing e-mail messages are routinely monitored for compliance with our IT Security, and Email/Internet Policy.

This signature also confirms that this email message has been swept for the presence of computer viruses and malicious code.

***************************************************************************************************************

Dim ond y sawl y mae'r ddogfen hon wedi'i chyfeirio atynt ddylai ei darllen, a'i defnyddio ganddynt ar gyfer ei dibenion bwriadedig; ac ni ddylid fel arall ei hatgynhyrchu, copio, lledaenu, datgelu, addasu, dosbarthu, cyhoeddi na'i rhoi ar waith chwaith. Os ydych chi wedi derbyn yr e-bost hwn trwy gamgymeriad, byddwch cystal a rhoi gwybod i ni ar unwaith trwy ffonio 01437 764551 a'i ddileu oddi ar eich cyfrifiadur ar unwaith. Ni ddylid rhoi'r cyfeiriad e-bost i unrhyw drydydd parti na'i ddefnyddio ar gyfer unrhyw ddiben arall chwaith.

Gwefan Cyngor Sir Penfro - http://www.pembrokeshire.gov.uk

Sylwer: Mae negeseuon e-bost sy’n cael eu hanfon a’u derbyn yn cael eu monitro’n rheolaidd ar gyfer cydymffurfio â’n Diogelwch TG, a’n Polisi E-bost/Rhyngrwyd.

Mae'r llofnod hwn hefyd yn cadarnhau bod y neges e-bost hon wedi cael ei harchwilio am fodolaeth firysau cyfrifiadurol a chod maleisus.

***************************************************************************************************************