[Osgeo4w-trac] [osgeo4w] #448: OGR2OGR Cannot Open Shapefile in to SQL Server 2014

OSGeo4W trac_osgeo4w at osgeo.org
Fri Dec 5 05:24:34 PST 2014


#448: OGR2OGR Cannot Open Shapefile in to SQL Server 2014
--------------------+-------------------------------------------------------
Reporter:  nrakich  |       Owner:  osgeo4w-dev@…              
    Type:  defect   |      Status:  new                        
Priority:  major    |   Component:  Package                    
 Version:           |    Keywords:                             
--------------------+-------------------------------------------------------
 Hello,

 Ogr2ogr does not seem able to open shapefiles with SQL Server 2014 drivers
 (for loading, reprojecting to the database).  Are there any patches that
 can be applied that would resolve this?  I am able to successfully load
 them to SQL Server 2012.

 Syntax [removed server and database name]
 ogr2ogr -f "MSSQLSpatial"
 "MSSQL:server=[SERVERNAME];database=[DBNAME];trusted_connection=yes"
 "cb_2013_55_tract_500k.shp" -s_srs "EPSG:4269" -t_srs "EPSG:4326"
 -overwrite -lco "GEOM_TYPE=geography" -lco "GEOM_NAME=geog4326" -nln
 "ShapeWiCensusTract"

 Reply
 "Unable to open datasource 'cb_2015_55_tract.shp' with the following
 drivers".
 (then list of about 45 drivers, including MSSQLSpatial, which is specified
 in the command line.

 Best Regards,
 Nick

-- 
Ticket URL: <http://trac.osgeo.org/osgeo4w/ticket/448>
OSGeo4W <http://trac.osgeo.org/osgeo4w>
OSGeo4W is the Windows installer and package environment for the OSGeo stack.


More information about the Osgeo4w-trac mailing list