[Qgis-user] Export to SQL Server plugin
Rikesh Lad
rikeshlad123 at gmail.com
Wed Nov 30 04:12:40 PST 2022
Hello,
I am having an issue loading either a postgis layer or sql server layer
into a sql server database using the Export to SQL Server plugin. I have
attached the two error log files. My QGIS version is 3.28.0-Firenze.
Rikesh
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20221130/93137ce0/attachment.htm>
-------------- next part --------------
QGIS version: 3.28.0-Firenze
QGIS code revision: ed3ad0430f3
Qt version: 5.15.3
Python version: 3.9.5
GDAL version: 3.5.2
GEOS version: 3.10.3-CAPI-1.16.1
PROJ version: Rel. 9.1.0, September 1st, 2022
PDAL version: 2.4.3 (git-version: 434757)
Algorithm started at: 2022-11-30T12:05:50
Algorithm 'Export to SQL Server (new connection)' starting…
Input parameters:
{ 'ADDFIELDS' : False, 'APPEND' : False, 'A_SRS' : None, 'CLIP' : False, 'DATABASE' : '', 'DIM' : 0, 'DRIVER' : 'ODBC Driver 17 for SQL Server', 'FIELDS' : [], 'GEOCOLUMN' : 'geom', 'GT' : '', 'GTYPE' : 0, 'INDEX' : False, 'INPUT' : 'postgres://dbname=\'test\' host=localhost port=5432 user=\'postgres\' password=\'1234\' sslmode=disable key=\'id\' srid=4326 type=Polygon checkPrimaryKeyUnicity=\'1\' table="client"."client1" (geom)', 'LAUNDER' : False, 'MSSQLSPATIAL_USE_BCP' : False, 'MSSQLSPATIAL_USE_GEOMETRY_COLUMNS' : True, 'OPTIONS' : '', 'OVERWRITE' : False, 'PASSWORD' : '', 'PK' : 'id', 'PRECISION' : True, 'PRIMARY_KEY' : '', 'PROMOTETOMULTI' : True, 'SCHEMA' : '', 'SEGMENTIZE' : '', 'SERVER' : '', 'SHAPE_ENCODING' : '', 'SIMPLIFY' : '', 'SKIPFAILURES' : False, 'SPAT' : None, 'S_SRS' : None, 'TABLE' : '', 'T_SRS' : None, 'USER' : '', 'WHERE' : '' }
GDAL command:
cmd.exe /C ogr2ogr.exe -progress -f MSSQLSpatial "MSSQL:driver={ODBC Driver 17 for SQL Server};" -lco DIM=2 "PG:dbname='test' host=localhost port=5432 user='postgres' password='1234' sslmode=disable" client.client1 -lco GEOMETRY_NAME=geom -lco FID=id -nln client.client1 -nlt PROMOTE_TO_MULTI --config MSSQLSPATIAL_USE_BCP NO
GDAL command output:
ERROR 1: Unable to find driver `MSSQLSpatial'.
Process returned error code 1
Execution completed in 0.18 seconds
Results:
{}
Loading resulting layers
Algorithm 'Export to SQL Server (new connection)' finished
-------------- next part --------------
QGIS version: 3.28.0-Firenze
QGIS code revision: ed3ad0430f3
Qt version: 5.15.3
Python version: 3.9.5
GDAL version: 3.5.2
GEOS version: 3.10.3-CAPI-1.16.1
PROJ version: Rel. 9.1.0, September 1st, 2022
PDAL version: 2.4.3 (git-version: 434757)
Algorithm started at: 2022-11-30T12:06:39
Algorithm 'Export to SQL Server (new connection)' starting…
Input parameters:
{ 'ADDFIELDS' : False, 'APPEND' : False, 'A_SRS' : None, 'CLIP' : False, 'DATABASE' : '', 'DIM' : 0, 'DRIVER' : 'ODBC Driver 17 for SQL Server', 'FIELDS' : [], 'GEOCOLUMN' : 'geom', 'GT' : '', 'GTYPE' : 0, 'INDEX' : False, 'INPUT' : 'mssql://dbname=\'test\' host=localhost\\mssqlserver01 estimatedmetadata=true srid=4326 type=MultiPolygon disableInvalidGeometryHandling=\'0\' extentInGeometryColumns=\'0\' table="dbo"."test1" (geom)', 'LAUNDER' : False, 'MSSQLSPATIAL_USE_BCP' : False, 'MSSQLSPATIAL_USE_GEOMETRY_COLUMNS' : True, 'OPTIONS' : '', 'OVERWRITE' : False, 'PASSWORD' : '', 'PK' : 'id', 'PRECISION' : True, 'PRIMARY_KEY' : '', 'PROMOTETOMULTI' : True, 'SCHEMA' : '', 'SEGMENTIZE' : '', 'SERVER' : '', 'SHAPE_ENCODING' : '', 'SIMPLIFY' : '', 'SKIPFAILURES' : False, 'SPAT' : None, 'S_SRS' : None, 'TABLE' : '', 'T_SRS' : None, 'USER' : '', 'WHERE' : '' }
GDAL command:
cmd.exe /C ogr2ogr.exe -progress -f MSSQLSpatial "MSSQL:driver={ODBC Driver 17 for SQL Server};" -lco DIM=2 MSSQL:database=test;server=localhost\mssqlserver01;trusted_connection=yes;tables=test1 dbo.test1 -lco GEOMETRY_NAME=geom -lco FID=id -nln dbo.test1 -nlt PROMOTE_TO_MULTI --config MSSQLSPATIAL_USE_BCP NO
GDAL command output:
FAILURE:
Unable to open datasource `MSSQL:database=test;server=localhost\mssqlserver01;trusted_connection=yes;tables=test1' with the following drivers.
-> `PCIDSK'
-> `netCDF'
-> `PDS4'
-> `VICAR'
-> `JP2ECW'
-> `JP2OpenJPEG'
-> `PDF'
-> `MBTiles'
-> `BAG'
-> `EEDA'
-> `OGCAPI'
-> `ESRI Shapefile'
-> `MapInfo File'
-> `UK .NTF'
-> `LVBAG'
-> `OGR_SDTS'
-> `S57'
-> `DGN'
-> `OGR_VRT'
-> `Memory'
-> `CSV'
-> `NAS'
-> `GML'
-> `GPX'
-> `LIBKML'
-> `KML'
-> `GeoJSON'
-> `GeoJSONSeq'
-> `ESRIJSON'
-> `TopoJSON'
-> `Interlis 1'
-> `Interlis 2'
-> `OGR_GMT'
-> `GPKG'
-> `SQLite'
-> `ODBC'
-> `WAsP'
-> `PGeo'
-> `OGR_OGDI'
-> `PostgreSQL'
-> `MySQL'
-> `OCI'
-> `OpenFileGDB'
-> `DXF'
-> `CAD'
-> `FlatGeobuf'
-> `Geoconcept'
-> `GeoRSS'
-> `VFK'
-> `PGDUMP'
-> `OSM'
-> `GPSBabel'
-> `OGR_PDS'
-> `WFS'
-> `OAPIF'
-> `SOSI'
-> `EDIGEO'
-> `SVG'
-> `Idrisi'
-> `XLS'
-> `ODS'
-> `XLSX'
-> `Elasticsearch'
-> `Carto'
-> `AmigoCloud'
-> `SXF'
-> `Selafin'
-> `JML'
-> `PLSCENES'
-> `CSW'
-> `VDV'
-> `GMLAS'
-> `MVT'
-> `NGW'
-> `MapML'
-> `Parquet'
-> `Arrow'
-> `TIGER'
-> `AVCBin'
-> `AVCE00'
-> `HTTP'
Process returned error code 1
Execution completed in 0.11 seconds
Results:
{}
Loading resulting layers
Algorithm 'Export to SQL Server (new connection)' finished
More information about the Qgis-user
mailing list