[Qgis-user] QGIS MSSQL 2008 Data import problem

[Noli Sicad]

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