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
