[Qgis-user] QGIS MSSQL 2008 Data import problem

[Noli Sicad]

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 <tomkom at 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" <nsicad at 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
>>
>>