[Qgis-user] MS localdb crash error

Mon Jun 11 22:56:53 PDT 2018

Hi Chris,

I cannot comment speficially on your crash, but I had a better experience
connecting to an MS Access Database via ODBC when I used an OGR Virtual
Format and used the file directly in QGIS instead of doing the connection
in QGIS.

Here are some links that might help you creating such a file to connect to
your DB:

http://www.gdal.org/drv_odbc.html

http://www.gdal.org/drv_vrt.html

and an example:

<OGRVRTDataSource>

    <OGRVrtLayer name="Naturmerkmale">

<SrcDataSource>ODBC:USER/PW at DB,Naturmerkmale,Beziehung</SrcDataSource>

        <SrcSQL>

            SELECT "ID", "Nummer", "Art", "Baumart", "Durchmesser", "Letzte
Messung", "Bemerkung", "Preisgruppe",

            "GK-Rechtswert" as rechtswert, "GK-Hochwert" as hochwert,

            (

                SELECT COUNT(*) FROM "Beziehung" AS b WHERE n."ID" =
b."Naturmerkmal"

            ) AS anzahl

            FROM "Naturmerkmale" AS n

            WHERE "GK-Rechtswert" > 0

        </SrcSQL>

        <LayerSRS>EPSG:31467</LayerSRS>

        <GeometryType>wkbPoint</GeometryType>

        <GeometryField encoding="PointFromColumns" x="rechtswert"
y="hochwert" />

    </OGRVrtLayer>

</OGRVRTDataSource>

HTH

Frank

Dipl. Geogr. Frank Broniewski

Waldhölzbacher Str. 51

66679 Losheim am See

06872 509 068 4

0176 611 26 9 2 6

www.frankbroniewski.com <http://www.frankbroniewski.com> 

Von: Qgis-user <qgis-user-bounces at lists.osgeo.org> Im Auftrag von Franklin,
Chris - Perth.
Gesendet: Dienstag, 12. Juni 2018 01:44
An: Qgis-user at lists.osgeo.org
Betreff: [Qgis-user] MS localdb crash error

Hi,

I have an ODBC connection to a MS localDB on my machine, I have a
spatialised view in that Db showing only 2 point currently collected by a 3
party piece of software via an internal GPS unit, I can bring into QGIS but
if I zoom in and out QGIS crashes  see report below. No other layers are
loaded - im running QGIS3 on Windows 10. I have also tried in QGIS 2.18.20
with the same result.

h2. User Feedback

h2. Report Details

*Crash ID*: a3e6a017d398405b26144fef17da819ca6a5a747

*Stack Trace*

<pre>

RtlEnterCriticalSection :

SQLDisconnect :

LockHandle :

SQLGetStmtAttrW :

isProvider :

isProvider :

isProvider :

QgsVectorLayerFeatureIterator::QgsVectorLayerFeatureIterator :

QgsVectorLayerFeatureSource::getFeatures :

QgsVectorLayerLabelProvider::registerFeature :

QgsMapRendererCustomPainterJob::doRender :

QgsMapRendererCustomPainterJob::staticRender :

QgsMapRendererJob::renderingTime :

QThreadPoolPrivate::reset :

QThread::start :

BaseThreadInitThunk :

RtlUserThreadStart :

</pre>

*QGIS Info*

QGIS Version: 3.0.3-Girona

QGIS code revision: commit:8a899c8758

Compiled against Qt: 5.9.2

Running against Qt: 5.9.2

Compiled against GDAL: 2.2.4

Running against GDAL: 2.2.4

*System Info*

CPU Type: x86_64

Kernel Type: winnt

Kernel Version: 10.0.16299

Any help gratefully received. 

Kind Regards

Chris

Kind Regards

Chris Franklin 
Senior GIS Officer 

Level 2, Australia Place, 15 - 17 William Street
Perth, Western Australia 6000

T: +61 8 9261 6100  |  D: +61 8 9261 6127 |  M: +61 420 665660

 <http://www.rml.com.au/> www.rml.com.au

Please consider the environment before printing this email.

This email and any attached files are confidential and may be legally
privileged. If you are not the intended recipient, any disclosure,
reproduction, copying, distribution, or other dissemination or use of this
communication is strictly prohibited. If you have received this transmission
in error, please notify the sender immediately and then delete this email.
Email transmission cannot be guaranteed to be secure or error free as
information could be intercepted, corrupted, lost, destroyed, arrive late or
incomplete, or contain viruses. The sender therefore is in no way liable for
any errors or omissions in the content of this message, which may arise as a
result of email transmission. If verification is required, please request a
hard copy.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20180612/0e9549d1/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 5219 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20180612/0e9549d1/attachment.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 5488 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20180612/0e9549d1/attachment.bin>