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@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 <[email protected]> Im Auftrag von Franklin, Chris - Perth. Gesendet: Dienstag, 12. Juni 2018 01:44 An: [email protected] 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.
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ Qgis-user mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
