On Thu, 6 Dec 2018 at 05:37, kimaidou <kimai...@gmail.com> wrote: > > 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) >
Sounds like an issue with fetching by primary key/feature ID. Is there any difference between the primary key setup on these tables vs the ones which work? Nyall > Have anyone seen this behaviour before ? > > Cheers > Michaël > > Le lun. 19 nov. 2018 à 00:12, Nyall Dawson <nyall.daw...@gmail.com> a écrit : >> >> On Sat, 17 Nov 2018 at 02:01, kimaidou <kimai...@gmail.com> 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 >> > QGIS-Developer@lists.osgeo.org >> > List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer >> > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer _______________________________________________ QGIS-Developer mailing list QGIS-Developer@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer