[Qgis-user] Problems with MS SQL Server 2010 and QGIS 2.18.x / 3.2.x

[Burghardt.Scholle at stadt.wolfsburg.de]

Hi list,

I have big problems loading MS SQL Server 2010 data with QGIS 2.18 and QGIS 3.2.x. Up to version 2.14 there were no problems. With 2.18 QGIS crashes after a few steps (zooming, moving, identifying etc.) with a minidump. Here I could reduce the behavior a bit, after disabling the option "Draw layers with many CPU cores in parallel". Nevertheless, access does not function completely smoothly. Especially during intensive, longer work with the data, there are repeated crashes.

Under QGIS 3.2.1, productive work is not possible at all. The MS SQL data can be added to the project, but QGIS crashes after just one or two steps:

*Crash ID*: 7c868adf9b18d0dbc3a8d4dd55f9dcf5a92ff5b0


*Stack Trace*
<pre>
RtlEnterCriticalSection :
SQLAllocHandle :
SQLGetStmtOption :
SQLGetStmtAttrW :
sourceSelectProviders :
sourceSelectProviders :
sourceSelectProviders :
QgsVectorLayerFeatureIterator::QgsVectorLayerFeatureIterator :
QgsVectorLayerFeatureSource::getFeatures :
QgsProcessingFeedback::~QgsProcessingFeedback :
QgsMapRendererCustomPainterJob::doRender :
QgsMapRendererCustomPainterJob::staticRender :
QgsMapRendererCustomPainterJob::renderSynchronously :
QThreadPoolPrivate::reset :
QThread::start :
BaseThreadInitThunk :
RtlUserThreadStart :
</pre>

*QGIS Info*
QGIS Version: 3.2.1-Bonn
QGIS code revision: commit:1edf372fb8
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: 6.1.7601

Does anyone have similar problems with MS SQL data?  I would be very grateful for any hint or tip.

Kind regards
Burghardt

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

Stadt Wolfsburg
Geschäftsbereich IT - 15-3 GIS
Rathaus E, Zi. E 313, Porschestraße 47A, D-38440 Wolfsburg
Tel +49 5361 28-2531
Fax +49 5361 28-1765
mailto:burghardt.scholle at stadt.wolfsburg.de