Thanks for your answers. I managed to connect with QGIS MSSQL native provider under my Debian box with the following steps https://gist.github.com/mdouchin/64f7733a3c4ecfe441f65d5529351a30
I have a weird behaviour. For some layers, QGIS Desktop cannot display the features attributes : the attribute table is empty, and the identify tool returns no feature. BUT I can see the points in my map, so QGIS can query the geography field from the database. For some other layers, wich seems identical (same structure for example), I can see the attributes (full attribute table and identify OK) Have anyone seen this behaviour before ? Cheers Michaël Le lun. 19 nov. 2018 à 00:12, Nyall Dawson <[email protected]> a écrit : > On Sat, 17 Nov 2018 at 02:01, kimaidou <[email protected]> wrote: > > > > Hi all, > > > > I am trying to connect to a MSSQL server from a QGIS installed in a > Linux Debian Jessie computer. > > I have checked that the credentials are ok with the mssql-client from > Microsoft: > > > > mssql-cli -S myserver -U carto -P ******* -d MyBase > > > > I installed the following packages from debian and Microsoft repos : > > > > curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add - > > curl https://packages.microsoft.com/config/debian/8/prod.list > > /etc/apt/sources.list.d/mssql-release.list > > apt-get update > > ACCEPT_EULA=Y apt-get install -y mssql-cli unixodbc-dev mssql-tools > msodbcsql17 msodbcsql odbcinst libqt4-sql-tds libqt4-sql-odbc > > > > When I open QGIS and try to set up a connection, I use not DSN, and I > put my server "myserver" as the host. I add the user and password. > > Then try to list the databases, but I get this error > > > > [unixODBC][Driver Manager]Can't open lib 'SQL Server' : file not found > > This is all super-fragile. (Just another symptom of SQL Server's > inferiority IMO). > > Have a look at > https://github.com/qgis/QGIS/blob/master/.ci/travis/linux/docker-build-test.sh#L128 > for how the Travis testing environment sets up a connection, there may > be some clues there. > > Nyall > > > > > I tested with > > > > root@carto:~# odbcinst -j > > unixODBC 2.3.1 > > DRIVERS............: /etc/odbcinst.ini > > SYSTEM DATA SOURCES: /etc/odbc.ini > > FILE DATA SOURCES..: /etc/ODBCDataSources > > USER DATA SOURCES..: /root/.odbc.ini > > SQLULEN Size.......: 8 > > SQLLEN Size........: 8 > > SQLSETPOSIROW Size.: 8 > > > > So I checked /etc/odbcinst.ini which seems ok > > > > root@carto:~# cat /etc/odbcinst.ini > > [ODBC Driver 17 for SQL Server] > > Description=Microsoft ODBC Driver 17 for SQL Server > > Driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.2.so.0.1 > > UsageCount=1 > > > > [ODBC Driver 13 for SQL Server] > > Description=Microsoft ODBC Driver 13 for SQL Server > > Driver=/opt/microsoft/msodbcsql/lib64/libmsodbcsql-13.1.so.9.2 > > UsageCount=1 > > > > Should I install more packages ? Any help appreciated. > > > > Regards, > > Michaël > > > > _______________________________________________ > > QGIS-Developer mailing list > > [email protected] > > List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer > > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer >
_______________________________________________ QGIS-Developer mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
