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 t
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 n
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
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
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 tru
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
thanks for warning, in my case I do not care about geometries, so it's fine.
> interesting to know
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:
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
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
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
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
>
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=
12 matches
Mail list logo
