Re: [gdal-dev] connect mssql from linux

[Mateusz Loskot]

AFAIK, yes the new driver does support the extension API (I think the
driver installer let's you to install SDK for it).
The bcp utility that uses the driver is available on Linux.

Mateusz Loskot, mate...@loskot.net
(Sent from mobile)

On Tue, 8 May 2018, 22:10 Jeremy Palmer,  wrote:

> But does the ODBC driver support the BCP (bulk copy) API? That was the
> original reason to use the native client.
>
> On Wed, May 9, 2018 at 8:06 AM, Mateusz Loskot  wrote:
>
>> FYI, the SQL Server Native Client is not the best choice to connect to
>> the latest MSSQL.
>> You may want to to switch to the new driver available for both, Linux and
>> Windows
>>
>>
>> https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server
>>
>> Mateusz Loskot, mate...@loskot.net
>> (Sent from mobile)
>>
>
>
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev

Re: [gdal-dev] connect mssql from linux

[Jeremy Palmer]

But does the ODBC driver support the BCP (bulk copy) API? That was the
original reason to use the native client.

On Wed, May 9, 2018 at 8:06 AM, Mateusz Loskot  wrote:

> FYI, the SQL Server Native Client is not the best choice to connect to the
> latest MSSQL.
> You may want to to switch to the new driver available for both, Linux and
> Windows
>
> https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/
> installing-the-microsoft-odbc-driver-for-sql-server
>
> Mateusz Loskot, mate...@loskot.net
> (Sent from mobile)
>
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev

Re: [gdal-dev] connect mssql from linux

[Mateusz Loskot]

FYI, the SQL Server Native Client is not the best choice to connect to the
latest MSSQL.
You may want to to switch to the new driver available for both, Linux and
Windows

https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server

Mateusz Loskot, mate...@loskot.net
(Sent from mobile)

On Tue, 8 May 2018, 18:44 Martin Landa,  wrote:

> Hi,
>
> 2018-05-07 1:37 GMT+02:00 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.
>
> my experience is even worse. It truncate in my case all strings (even
> short strings with two characters). Just first character is written do
> DB! Martin
>
> --
> Martin Landa
> http://geo.fsv.cvut.cz/gwiki/Landa
> http://gismentors.cz/mentors/landa
> ___
> gdal-dev mailing list
> gdal-dev@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/gdal-dev
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev

Re: [gdal-dev] connect mssql from linux

[Tamas Szekeres]

What if you disable bulk insert with "-config MSSQLSPATIAL_USE_BCP NO" ?

Best regards,

Tamas


2018-05-08 18:44 GMT+02:00 Martin Landa :

> Hi,
>
> 2018-05-07 1:37 GMT+02:00 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.
>
> my experience is even worse. It truncate in my case all strings (even
> short strings with two characters). Just first character is written do
> DB! Martin
>
> --
> Martin Landa
> http://geo.fsv.cvut.cz/gwiki/Landa
> http://gismentors.cz/mentors/landa
> ___
> gdal-dev mailing list
> gdal-dev@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/gdal-dev
>
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev

Re: [gdal-dev] connect mssql from linux

[Martin Landa]

Hi,

2018-05-07 1:37 GMT+02:00 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.

my experience is even worse. It truncate in my case all strings (even
short strings with two characters). Just first character is written do
DB! Martin

-- 
Martin Landa
http://geo.fsv.cvut.cz/gwiki/Landa
http://gismentors.cz/mentors/landa
___
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev