[FWTools] ogr2ogr for extracting non-spatial data from ODBC datasource

[Simon O'Keefe]

Hi,

I'm attempting to use ogr2ogr to extract data from a non-spatial
Oracle database and output to a CSV file.

When I enter:
ogr2ogr -f CSV C:\Temp\CGData
ODBC:gissvr/gis123 at pth_prod,gissvr.COMMONGROUND_ADDRESS

I get:
ERROR 1: No column definitions found for table
'gissvr.COMMONGROUND_ADDRESS', layer not usable.

I'm trying to follow the syntax example on the ODBC RDBMS page
(http://www.gdal.org/ogr/drv_odbc.html), but it says I need to put the
name of a geometry column in brackets after the table name. How can I
get ogr2ogr to recognise the data source as a non-spatial table (ie,
no geometry column)?

I'm running FWTools 2.4.3 on Windows XP Pro SP3

Cheers,

Simon
_______________________________________
Simon O'Keefe
Geospatial Systems Developer
Groundtruth Mapping Systems
Level 2, 140 Queen Street
Melbourne VIC 3000 Australia
mobile: +61 409 413 890
office: +61 3 9017 6850
email:  simon.okeefe at groundtruth.com.au
web:    http://www.groundtruth.com.au
_______________________________________