[Qgis-user] QGIS Server on Debian - MSSqlServer layer

[chris hermansen]

Francesco and list,

Please look at this
http://osgeo-org.1560.x6.nabble.com/QGIS-Developer-MSSQL-driver-not-found-amp-Can-t-open-lib-SQL-Server-QGIS-2-18-LTR-on-Debian-td5386050.html

On Fri, Jul 3, 2020, 01:16 Francesco D Alesio <francesco.dalesio at ies.it>
wrote:

> 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 at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200703/7d7980c7/attachment.html>