Von: James Wood [mailto:jwood...@gmail.com]
Gesendet: Dienstag, 5. Mai 2015 12:44
An: Peter Schürch
Betreff: Re: AW: [Qgis-user] Add mssql non-geometric tables
Peter,
I am also running 2014. It's a good question to ask, and honestly I'm not sure
what the specifics are for a recogn
for
QGIS? Is there any meta information needed somewhere?
Hopefully you can make some sense of this.
Cheers, Peter
Von: James Wood [mailto:jwood...@gmail.com<mailto:jwood...@gmail.com>]
Gesendet: Samstag, 2. Mai 2015 16:22
An: Peter Schürch
Betreff: Re: [Qgis-user] Add mssql non-geometric tab
Ah yes, and we're running SQL Server 2014.
Peter
-Ursprüngliche Nachricht-
Von: Peter Schürch
Gesendet: Montag, 4. Mai 2015 07:31
An: 'James Wood'
Cc: Qgis Mailinglist (qgis-user@lists.osgeo.org)
Betreff: AW: [Qgis-user] Add mssql non-geometric tables
Hi James
Unfortun
ginal question: what makes a flat table
> valid for QGIS? Is there any meta information needed somewhere?
> Hopefully you can make some sense of this.
>
> Cheers, Peter
>
> Von: James Wood [mailto:jwood...@gmail.com]
> Gesendet: Samstag, 2. Mai 2015 16:22
> An: Peter Schürch
om]
Gesendet: Samstag, 2. Mai 2015 16:22
An: Peter Schürch
Betreff: Re: [Qgis-user] Add mssql non-geometric tables
Hey Peter,
Yes, the problem is a little clearer now, thanks. When adding what we refer to
here as a "flat table" (i.e., no geometry), it always just adds as a table
object, s
Hi James
Thanks for getting back to me.
I'using Wien too.
The database connection is established. I can add existing geometry layers from
the DB to the qgis project. I can also add new layers to the DB (e.g. A shape).
So no fundamental problem with the DB.
My problem is the following.
I have def
e images (Susan Iremonger)
--
Message: 1
Date: Thu, 30 Apr 2015 18:55:43 +
From: Peter Sch?rch
To: "qgis-user@lists.osgeo.org"
Subject: [Qgis-user] Add mssql non-geometric tables
Message-ID: <08dfdfed-18e9-49f3-b359-a22c069c7...@meierpartner.ch>
Content-Type: text/pla
Hi
Does anybody know how to add a non-geometric table from an mssql database to a
qgis project?
Do I need to add it in the table "geometry_columns"? If yes what would be the
appropriate attribute values there?
Thanks
Peter Schürch
--
Meier und Partner AG
Freiestrasse 26
8570 Weinfelden
www.meier