[QGIS-Developer] QGIS and MSSQL Spatial

[Alexander Bruy]

Ah, before testing connection one should get list of the databases.
Quite confusing and not coherent with all other database providers.

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