Re: [Qgis-user] QGIS MSSQL 2008 Data import problem
Dear Noli, Thanks for the helpful posts. I managed to configure iODBC with an OpenLInk driver (not free, using a trial licence for the moment) on my Mac. The test connection from the iODBC Administrator is established without problem. I am however, not able to get the connection established through QGIS. It still complains that a driver is not found .To me, this suggests that the driver installed and discovered by iODBC is not discovered by QGIS Is there some environmental variable you need to set to make it work, for QGIS? Thanks, Martin ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] QGIS MSSQL 2008 Data import problem
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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] QGIS MSSQL 2008 Data import problem
Hi Martin, I think you need freetds as well with iodbc in order to mssql to work with Mac OS X. http://www.freetds.org/index.html http://www.freetds.org/userguide/odbcdiagnose.htm#WITH.IODBC As I understand, we need to have a connection with the MS SQL server with Mac OS X Operating system first. MS SQL -- Mac OS X--- QGIS with MSSQL support. Last time, I was dealing with iODBC in Mac OS X, when I was compiling GPLK with iODBC inorder I can write my GLPK solution into Spatialite database. I hope you make it working. Noli On 7/6/12, Martin Tomko tom...@unimelb.edu.au wrote: Dear Noli, Thank you for your feedback. I was under the impression that the GDAL drivers are used. The requirement for iodbc was not documented anywhere in the dependencies. Even after downloading and installing the iODBC framework,. I am not able to connect. It seems that you need to configure iODBC somehow - and specify a driver - but the list is empty. Should I point it to GDAL or somewhere else? Thanks, Martin On 6/07/12 4:24 PM, Noli Sicad nsi...@gmail.com wrote: Hi Martin, You need iodbc for Mac and Linux to connect to MS products (e.g. MSSQL, excel, etc.). You can't connect to MS SQL without providing the DSN and password. Here is the link for iodbc snow leopard. http://www.iodbc.org/dataspace/iodbc/wiki/iODBC/Downloads#Mac%20OS%20X You need to configure the iodbc in Mac OS X and Ubuntu as well. iODBC package is available in Ubuntu as well. Noli ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] QGIS MSSQL 2008 Data import problem
Martin, have a look at this archive as well. [freetds] Cannot connect to MS SQL 2008 server from OS X using FreeTDS http://lists.ibiblio.org/pipermail/freetds/2012q2/subject.html Noli On 7/6/12, Noli Sicad nsi...@gmail.com wrote: Hi Martin, I think you need freetds as well with iodbc in order to mssql to work with Mac OS X. http://www.freetds.org/index.html http://www.freetds.org/userguide/odbcdiagnose.htm#WITH.IODBC As I understand, we need to have a connection with the MS SQL server with Mac OS X Operating system first. MS SQL -- Mac OS X--- QGIS with MSSQL support. Last time, I was dealing with iODBC in Mac OS X, when I was compiling GPLK with iODBC inorder I can write my GLPK solution into Spatialite database. I hope you make it working. Noli On 7/6/12, Martin Tomko tom...@unimelb.edu.au wrote: Dear Noli, Thank you for your feedback. I was under the impression that the GDAL drivers are used. The requirement for iodbc was not documented anywhere in the dependencies. Even after downloading and installing the iODBC framework,. I am not able to connect. It seems that you need to configure iODBC somehow - and specify a driver - but the list is empty. Should I point it to GDAL or somewhere else? Thanks, Martin On 6/07/12 4:24 PM, Noli Sicad nsi...@gmail.com wrote: Hi Martin, You need iodbc for Mac and Linux to connect to MS products (e.g. MSSQL, excel, etc.). You can't connect to MS SQL without providing the DSN and password. Here is the link for iodbc snow leopard. http://www.iodbc.org/dataspace/iodbc/wiki/iODBC/Downloads#Mac%20OS%20X You need to configure the iodbc in Mac OS X and Ubuntu as well. iODBC package is available in Ubuntu as well. Noli ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user