[Qgis-user] MS SQL Server connection on Linux

[Fernando M. Roxo da Motta]

On Mon, 26 Jul 2021 15:37:00 -0300, "Fernando M. Roxo da Motta"
<petro at roxo.org> wrote:


> On Mon, 26 Jul 2021 16:33:23 +0200, Paolo Cavallini
> <cavallini at faunalia.it> wrote:
> 
> 
> > Hi all,
> > we could not find any documentation on how to connect a Linux
> > (Debian stable, more specifically) box to a Microsoft SQL Server
> > database. It works out of the box on Windows, but on Linux it
> > complains about a missing driver. I assume to have it working one
> > should install some proprietary part from Microsoft, and perhaps do
> > some config on the qgis side.
> > Are we missing something? Should this info made available
> > somewhere?  
> 
>   Perhaps you are missing the unixodbc package and companions.  There
> should exist a package with the drivers for MS SQL.

  Sorry to answer myself,  it seems that the MS SQG driver is in
package odbc-mdbtools:

This is the software driver to access JET / MS Access database (MDB)
files through ODBC.
This also contains the installation interface for unixodbc.



> 
>   HTH
> 
> 
> > Thanks in advance.  
> 
> 
> 
> 
> 
> 
> 
> 
>   Roxo
> 








  Roxo

-- 
---------------- Non luctari, ludare -------------------+ WYSIWYG
Fernando M. Roxo da Motta <petro at roxo.org>              | Editor?
Except where explicitly stated I speak on my own behalf.|  VI !!
                PU5RXO | PX5Q6048                       | I see text,
------------ Quis custodiet ipsos custodes?-------------+ I get text!