You will need to create a DSN and use that rather then a direct connection.  Seems to be a thing with the Qt ODBC driver and not being able to use the direct connection string on Linux and Mac OS.  On Windows using the parameters without a DSN works fine.<div>

<br></div><div>- Nathan<br><br><div class="gmail_quote">On Fri, Jul 6, 2012 at 3:51 PM, Martin Tomko <span dir="ltr"><<a href="mailto:tomkom@unimelb.edu.au" target="_blank">tomkom@unimelb.edu.au</a>></span> wrote:<br>

<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">





<div style="font-size:14px;font-family:Calibri,sans-serif;word-wrap:break-word">
<div>
<div>
<div>Dear all,</div>
</div>
</div>
<div>We were – for the first time – trying to visualize some data held in SQL Server 2008 by a remote collaborator. The data are held in a table with a spatial column.</div>
<div><br>
</div>
<div>I was hoping to use the new feature in QGIS, but was getting into troubles. After filling the DB parameters (in the "pink" icon in QGIS 1.8) I got this message:</div>
<div><br>
</div>
<div>"<span style="white-space:pre-wrap">Driver not loaded Driver not loaded</span>"</div>
<div><br>
</div>
<div>We filled all parameters in the connection window, without using Provider/DSN.</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div>System information:</div>
<div><br>
</div>
<div>QGIS</div>
<div>The about menu gives me:</div>
<div>
<table border="0" style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px" align="center" width="100%" cellspacing="2" cellpadding="0">
<tbody>
<tr>
<td>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">
QGIS version</p>
</td>
<td>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">
1.8.0-Lisboa</p>
</td>
<td>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">
QGIS code revision</p>
</td>
<td></td>
</tr>
<tr>
<td>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">
Compiled against Qt</p>
</td>
<td>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">
4.8.1</p>
</td>
<td>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">
Running against Qt</p>
</td>
<td>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">
4.8.1</p>
</td>
</tr>
<tr>
<td>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">
Compiled against GDAL/OGR</p>
</td>
<td>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">
1.9.1</p>
</td>
<td>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">
Running against GDAL/OGR</p>
</td>
<td>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">
1.9.1</p>
</td>
</tr>
<tr>
<td>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">
GEOS Version</p>
</td>
<td>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">
3.3.2dev</p>
</td>
<td>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">
PostgreSQL Client Version</p>
</td>
<td>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">
9.1.4</p>
</td>
</tr>
<tr>
<td>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">
SpatiaLite Version</p>
</td>
<td>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">
3.0.1</p>
</td>
<td>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">
QWT Version</p>
</td>
<td>
<p style="margin-top:0px;margin-bottom:0px;margin-left:0px;margin-right:0px;text-indent:0px">
5.2.2</p>
</td>
</tr>
</tbody>
</table>
<br>
</div>
<div>OS:</div>
<div>Tested on Mac OSX (10.6.8) and Ubuntu / KUBUNTU</div>
<div><br>
</div>
<div>I wonder where the problem is… I did not find any related comments on the Web.</div>
<div><br>
</div>
<div>Thanks,</div>
<div>Martin</div>
</div>

<br>_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
<br></blockquote></div><br></div>