Can anyone tell me what the error is with OGR2OGR when trying to import a .SHP into MSSQLSPATIAL?
ERROR 1: MSSQL Spatial driver doesn't currently support database creation. Please create database with the Microsoft SQL Server Client Tools. MSSQLSpatial driver failed to create MSSQL:server=\;database =;uid=;pwd:
The import statement I'm using is this:
ogr2ogr -f MSSQLSpatial "MSSQL:server=\;database=;uid=;pwd:" C:\[path to file]\police_districts_2877.shp -a_srs EPSG:2877 -lco "GEOM_TYPE=geometry" -lco "GEOM_NAME=geom" -nln "CCD_PoliceDistricts" -progress
As you can see, I'm not trying to create a database, and there is one already created. as per the 'creation issue' cited here: http://www.gdal.org/ogr/drv_mssqlspatial.html
I have followed several posts, including this: Shapefile to MSSQL with ogr2ogr fails to make connection, to no avail...
EDIT: I'm also getting a connection error, but I can't see why...I think my syntax is correct:
ERROR 1: Unable to initialize connection to the server for MSSQL:server=\;database=;uid=;pwd:,[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '[username]'.