Opened 10 years ago
Closed 10 years ago
#5339 closed defect (fixed)
ogr2ogr fails to create spatial_ref_sys and geometry_columns tables in MSSQL 2012 database
| Reported by: | andyew | Owned by: | tamas |
|---|---|---|---|
| Priority: | normal | Milestone: | |
| Component: | OGR_SF | Version: | unspecified |
| Severity: | major | Keywords: | mssql spatial_ref_sys ogr2ogr |
| Cc: | tamas |
Description
Using a command line like this ogr2ogr -f MSSQLSpatial "MSSQL:server=RMDS04;database=Andrew_test;trusted_connection=yes" -lco "OVERWRITE=YES" "C:\REFMAP\SOURCE.TAB" -progress
The SOURCE table is created in the database with all the requisite columns. The tables spatial_ref_sys and geometry_columns are not.
Attached is a SQL Profiler Trace of the transaction. You'll see a couple of "Invalid object name" references to the two tables when these are queried and not found.
No error is reported during upload.
The ogr2ogr is from the 64 bit Windows version of QGIS(Dufour) found in the OSGeo4W64\bin directory and executed in the OSGeo4W Shell. The PC OS is Windows 8 64 bit.
Attachments (1)
Change History (4)
by , 10 years ago
| Attachment: | SQLProfilerTrace.csv added |
|---|
comment:1 by , 10 years ago
| Cc: | added |
|---|---|
| Component: | default → OGR_SF |
| Keywords: | mssql added |
comment:2 by , 10 years ago
| Owner: | changed from to |
|---|
comment:3 by , 10 years ago
| Resolution: | → fixed |
|---|---|
| Status: | new → closed |
Note:
See TracTickets
for help on using tickets.
SQL Profiler Trace