[Qgis-user] MSSQL connection problem

[Walter Lorenetti]

Hi all,

I have a problem with a MSSql connection.

My enviromnents:

So: Ubuntu 18.04

QGIS: 3.10.4

Installed msodbcsql17 from microsoft repository.

with a /etc/odbcinit.ini:

[SQL Server] Description=Microsoft ODBC Driver 17 for SQL Server 
Driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.5.so.2.1 
UsageCount=1

But when I try to do a connection I get a 'Driver not loaded Driver not 
loaded'.

My connection data:

Connection name: <my_custom_connection_name>

Provider/DNS: driver={SQL 
Server};server=<sql_server_ip>;port=1433;database=<my_dbname>

Host: <sql_server_ip>

Username: <my_uid_sql_server_username>

Password: <my_pwd_sql_server_password>

Where I'm in wrong?

Thanks in advance.

Walter

-- 

Walter Lorenzetti phD email: lorenzetti at gis3w.it skype: aiki74 
twitter:w_lorenzetti <https://twitter.com/w_lorenzetti> g+:aiki74 
<https://plus.google.com/117055903318462447104/> Tel/Cell: (+39) 
347-6597931 Viale Verdi 24 - 51016 Montecatini Terme (PT) Nuovi corsi 
QGIS e GFOSS <http://gis3w.it/it/calendario-corsi-software-geografici>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200417/b1e1de04/attachment.html>