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

[Bo Victor Thomsen]

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> On Behalf Of Mateusz
> Loskot
> Sent: 22 October 2018 16:31
> To: 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>
> 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
> 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
> 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/0adbca89/attachment-0001.html>