[QGIS-Developer] QGIS and MSSQL Spatial

Harrissou delazj at gmail.com
Sat Jul 20 00:47:51 PDT 2019


Hi,

Le 20 juillet 2019 09:14:25 GMT+02:00, Alexander Bruy <alexander.bruy at gmail.com> a écrit :
>Ah, before testing connection one should get list of the databases.
>Quite confusing and not coherent with all other database providers.

The UI itself is not coherent with the other providers.

Regards,
Harrissou
>
>Sorry for the noise.
>
>сб, 20 лип. 2019 о 09:52 Alexander Bruy <alexander.bruy at gmail.com>
>пише:
>>
>> Hi,
>>
>> I'm trying to connect to the MSSQL server with QGIS native MSSQL
>provider
>> on Windows. Database server uses standard port, TCP/IP access is
>enabled.
>> After specifying connection name, host and username/password and
>pressing
>> "Test connection" button I get an error
>>
>> Error opening connection : Driver not loaded Driver not loaded
>>
>> On other hand if I setup a system DSN using same parameters and
>> specify DSN instead of the host in the QGIS connections dialog
>> everything works.
>>
>> Am I miss something or native MSSQL provider works only with ODBC
>even
>> on Windows?
>>
>> --
>> Alexander Bruy
>
>
>
>-- 
>Alexander Bruy
>_______________________________________________
>QGIS-Developer mailing list
>QGIS-Developer at lists.osgeo.org
>List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
>Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer

-- 
Envoyé de mon appareil Android avec Courriel K-9 Mail. Veuillez excuser ma brièveté.


More information about the QGIS-Developer mailing list