Hello everybody,
I'm trying to display an MS Sql Server layer with QGIS Server (3.12) installed
on a Debian 10 machine.
The project is giving the "Layer(s) not valid" error, because of the MS Sql
Server layer (postgis layers are working properly).
I've installed the odbc driver, and now I can connect to sql server with
ogr2ogr, specifyng "Driver={ODBC Driver 17 for SQL Server}" in the connection
string.
Than I added a [SQL Server] section to /etc/odbcinst.ini , and now ogr2ogr
works without the Driver in the connection string.
But QGIS is still giving the "Layer(s) not valid" error.
I've also tried to add the driver name to the source attribute of the
layer-tree-layer element of the qgs file, without success.
Three questions:
1. What else can I try?
2. Is there a way to get more detailed error information? apache error logs are
empty, and QGIS_SERVER_LOG_FILE contains just the layer id
(QGIS_SERVER_LOG_LEVEL=0 and QGIS_DEBUG=9)
3. Do you recommend using windows instead of debian in this environment?
Thank you
Regards
Francesco
_______________________________________________
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
