Re: [gdal-dev] connect mssql from linux

2018-05-06 Thread Jeremy Palmer
Note I alway found the FreeTDS driver would truncate values on rows that contained large geometries. Can't remember the size limit though. Would be interesting to know why the LINUX native driver doesn't work. On Mon, May 7, 2018 at 9:33 AM, Martin Landa wrote: > Hi, > > 2018-05-06 23:22 GMT+02:

Re: [gdal-dev] connect mssql from linux

2018-05-06 Thread Martin Landa
Hi, 2018-05-06 23:22 GMT+02:00 Even Rouault : > Would be a good hint for the driver documentation page. Will do later (probably tomorrow). Ma -- Martin Landa http://geo.fsv.cvut.cz/gwiki/Landa http://gismentors.cz/mentors/landa ___ gdal-dev mailing li

Re: [gdal-dev] connect mssql from linux

2018-05-06 Thread Even Rouault
On dimanche 6 mai 2018 23:06:54 CEST Martin Landa wrote: > Hi, > > 2018-05-06 13:06 GMT+02:00 Martin Landa : > > For record, I managed to connect to MSSQL DB using tdsodbc > > sudo apt install unixodbc freetds-bin tdsodbc > > [SQL Server] > Description = FreeTDS driver > Driver = /usr/lib/x86_6

Re: [gdal-dev] connect mssql from linux

2018-05-06 Thread Martin Landa
Hi, 2018-05-06 13:06 GMT+02:00 Martin Landa : For record, I managed to connect to MSSQL DB using tdsodbc sudo apt install unixodbc freetds-bin tdsodbc [SQL Server] Description = FreeTDS driver Driver = /usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so Setup = /usr/lib/x86_64-linux-gnu/odbc/libtdsS.s

Re: [gdal-dev] connect mssql from linux

2018-05-06 Thread Martin Landa
2018-05-06 12:53 GMT+02:00 Martin Landa : > $ ogrinfo > "MSSQL:database=kn;server=host\kartografiesql;uid=landa;pwd=xxx;driver=ODBC > Driver 11 for SQL Server" --config CPL_DEBUG ON > > fails with > > ODBC: > SQLDriverConnect(database=kn;server=host\kartografiesql;uid=landa;pwd=xxx;driver=ODBC >

[gdal-dev] connect mssql from linux

2018-05-06 Thread Martin Landa
Hi, I have problem connecting SQL Server from my Linux machine. Command $ ogrinfo "MSSQL:database=kn;server=host\kartografiesql;uid=landa;pwd=xxx;driver=ODBC Driver 11 for SQL Server" --config CPL_DEBUG ON fails with ODBC: SQLDriverConnect(database=kn;server=host\kartografiesql;uid=landa;pwd=