[Qgis-user] QGIS MSSQL 2008 Data import problem

[Nathan Woodrow]

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.

- Nathan

On Fri, Jul 6, 2012 at 3:51 PM, Martin Tomko <tomkom at unimelb.edu.au> wrote:

>   Dear all,
>  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.
>
>  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:
>
>  "Driver not loaded Driver not loaded"
>
>  We filled all parameters in the connection window, without using
> Provider/DSN.
>
>
>
>  System information:
>
>  QGIS
> The about menu gives me:
>
> QGIS version
>
> 1.8.0-Lisboa
>
> QGIS code revision
>
> Compiled against Qt
>
> 4.8.1
>
> Running against Qt
>
> 4.8.1
>
> Compiled against GDAL/OGR
>
> 1.9.1
>
> Running against GDAL/OGR
>
> 1.9.1
>
> GEOS Version
>
> 3.3.2dev
>
> PostgreSQL Client Version
>
> 9.1.4
>
> SpatiaLite Version
>
> 3.0.1
>
> QWT Version
>
> 5.2.2
>
>  OS:
> Tested on Mac OSX (10.6.8) and Ubuntu / KUBUNTU
>
>  I wonder where the problem is… I did not find any related comments on
> the Web.
>
>  Thanks,
> Martin
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20120706/5165bca2/attachment.html>