[gdal-dev] Import Shapefile into SQL Server on Ubuntu

[Peter Marlow]

Hi Bo,

Yes the original commandstring did have that error, however the main error was that I didn’t have access to the MSSQLSpatial driver because the ODBC driver wasn’t bundled with the version of GDAL that I installed via conda-forge. When I installed GDAL via ‘apt-get install gdal-bin’ it did have the ODBC support.

Cheers,
Pete

From: gdal-dev <gdal-dev-bounces at lists.osgeo.org> On Behalf Of Bo Victor Thomsen
Sent: 30 November 2018 14:13
To: gdal-dev at lists.osgeo.org
Subject: Re: [gdal-dev] Import Shapefile into SQL Server on Ubuntu

Hi Pete -

Your first take on the commandstring probably contains an error...

ogr2ogr -f MSSQLSpatial  "MSSQL:server=localhost;database=[database-name];username=sa;password=*****;trusted_connection=yes" [path-to-shape-file]

You probably hasn't made the necessary setup with kerberos to use "integrated security" (the  "trusted_connection=yes" part in the connection string)

This command might have worked ( no trusted_connection parameter):
ogr2ogr -f MSSQLSpatial  "MSSQL:server=localhost;database=[database-name];username=sa;password=*****" [path-to-shape-file]

Your second take  doesn't contain the "trusted_connection" part
ogr2ogr -f MSSQLSpatial "MSSQL:server=[server];database=[database];uid=[username];Pwd=[password];Driver={ODBC Driver 17 for SQL Server}" [shape file]




--- Run ogr2ogr using driver
ogr2ogr -f MSSQLSpatial "MSSQL:server=[server];database=[database];uid=[username];Pwd=[password];Driver={ODBC Driver 17 for SQL Server}" [shape file]


Thanks,
Pete

-----Original Message-----
From: gdal-dev <gdal-dev-bounces at lists.osgeo.org<mailto:gdal-dev-bounces at lists.osgeo.org>> On Behalf Of Mateusz Loskot
Sent: 22 October 2018 16:31
To: gdal-dev at lists.osgeo.org<mailto:gdal-dev at lists.osgeo.org>
Subject: Re: [gdal-dev] Import Shapefile into SQL Server on Ubuntu

On Mon, 22 Oct 2018 at 17:25, Peter Marlow <Peter.Marlow at scisys.co.uk<mailto:Peter.Marlow at scisys.co.uk>> wrote:
>
> I’m trying to import a Shapefile into an SQL Server database using ogr2ogr on Ubuntu. The command I’m running looks like:
>
> ogr2ogr -f MSSQLSpatial
> "MSSQL:server=localhost;database=[database-name];username=sa;password=
> *****;trusted_connection=yes" [path-to-shape-file]
>
> It returns an error stating:
>
> ERROR 1: Unable to find driver `MSSQLSpatial'.

I guess, GDAL/OGR version you are using on Linux is not built with ODBC/SQL Server support.

> Is it possible to get the driver on linux? Or use an alternative driver? I’ve had a google and can’t seem to see any workarounds.
>
> The docs here (https://www.gdal.org/drv_mssqlspatial.html) talk about
> specifying a Driver parameter that could be a custom SQL Server driver, however this is in the connection string and not as a parameter for the ogr2ogr command.

Once you get GDAL/OGR built with SQL Server, install ODBC Driver for SQL Server (there are clear docs on Microsoft site, you will find easily searching the web)

Then, try sticking the Driver option into the connection string Driver={ODBC Driver 11 for SQL Server} Driver={ODBC Driver 13 for SQL Server} Driver={ODBC Driver 13.1 for SQL Server} Driver={ODBC Driver 17 for SQL Server} depending which version you install.

Best regards,
--
Mateusz Loskot, http://mateusz.loskot.net _______________________________________________
gdal-dev mailing list
gdal-dev at lists.osgeo.org<mailto:gdal-dev at lists.osgeo.org>
https://lists.osgeo.org/mailman/listinfo/gdal-dev


SCISYS UK Limited. Registered in England and Wales No. 4373530.
Registered Office: Methuen Park, Chippenham, Wiltshire SN14 0GB, UK.

Before printing, please think about the environment.

_______________________________________________
gdal-dev mailing list
gdal-dev at lists.osgeo.org<mailto:gdal-dev at lists.osgeo.org>
https://lists.osgeo.org/mailman/listinfo/gdal-dev


--
Med venlig hilsen

Bo Victor Thomsen

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20181130/27cbedd5/attachment.html>