<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-15">
</head>
<body>
<p>Hi all,</p>
<p>I have a problem with a MSSql connection.</p>
<p>My enviromnents:</p>
<p>So: Ubuntu 18.04</p>
<p>QGIS: 3.10.4</p>
<p>Installed msodbcsql17 from microsoft repository.</p>
<p>with a /etc/odbcinit.ini:</p>
<p>[SQL Server]
Description=Microsoft ODBC Driver 17 for SQL Server
Driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.5.so.2.1
UsageCount=1
</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">But when I try to do a connection I get a 'Driver not loaded Driver not loaded'.</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">
</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">My connection data:</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">
</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">Connection name: <my_custom_connection_name>
</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">Provider/DNS: driver={SQL Server};server=<sql_server_ip>;port=1433;database=<my_dbname>
</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">Host: <sql_server_ip></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">
</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">Username: <my_uid_sql_server_username></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">Password: <my_pwd_sql_server_password></p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">
</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">Where I'm in wrong?</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">Thanks in advance.</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">Walter
</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">
</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;">
</p>
<p><style type="text/css">
p, li { white-space: pre-wrap; }</style></p>
<div class="moz-signature">-- <br>
<p style="font-size:12px;">
Walter Lorenzetti phD
email: <a class="moz-txt-link-abbreviated" href="mailto:lorenzetti@gis3w.it">lorenzetti@gis3w.it</a>
skype: aiki74
twitter:<a href="https://twitter.com/w_lorenzetti">w_lorenzetti</a>
g+:<a href="https://plus.google.com/117055903318462447104/">aiki74</a>
Tel/Cell: (+39) 347-6597931
Viale Verdi 24 - 51016 Montecatini Terme (PT)
<a href="http://gis3w.it/it/calendario-corsi-software-geografici">Nuovi corsi QGIS e GFOSS</a>
</p>
</div>
</body>
</html>