Re: [Qgis-user] MS localdb crash error

2018-06-11 Thread Frank Broniewski 
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:



 





 
ODBC:USER/PW@DB,Naturmerkmale,Beziehung





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





EPSG:31467

wkbPoint











 

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  Im Auftrag von Franklin,
Chris - Perth.
Gesendet: Dienstag, 12. Juni 2018 01:44
An: Qgis-user@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*



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 :



 

 

*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.

 



smime.p7s
Description: S/MIME cryptographic signature
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

[Qgis-user] MS localdb crash error

2018-06-11 Thread Franklin, Chris - Perth. 
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*

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 :



*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

[RDG-Logo-Tagline]

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
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.

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user