[Qgis-user] Export to SQL Server plugin

[Andrea Giudiceandrea]

> Rikesh Lad rikeshlad123 at gmail.com
> Sat Feb 25 11:07:46 PST 2023

> Is there a way to change which drive the 'Export to SQL Server' plugin is
> looking for the ODBC Driver 17 for SQL Server? At the moment, it is looking
> in the F: drive but I need to change this to the C: drive. I'll highlight
> it in red text in the GDAL/OGR console call below.
> 
> ogr2ogr.exe -progress -f MSSQLSpatial "MSSQL:driver={ODBC Driver 17 for SQL...

Hi Rikesh,
the "-f" parameter of the ogr2ogr command doesn't mean that the command 
is "looking in  the F: drive".
The "-f" parameter is used to specify the output format name, that in 
your case, is "MSSQLSpatial ".

See https://gdal.org/programs/ogr2ogr.html#cmdoption-ogr2ogr-f

Best reagrds.

Andrea Giudiceandrea