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

[Richard Greenwood]

On Thu, Sep 3, 2009 at 7:58 PM, Simon O'Keefe <
simon.okeefe at groundtruth.com.au> wrote:

> 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 use ogr2ogr on non-spatial database w/o taking any special steps to
identify them as non-spatial. Your syntax looks generally correct to me. The
error "No column definitions found" is pretty general. I'd try using ogrinfo
to test the ODBC connection. Try leaving off the schema name, try defining
the user/pwd in the ODBC connection, etc.

Soory not to offer any more specific advise, but ogr2ogr is an awesome tool
for non-spatial data conversion and transfer, so it's worth the effort to
get it figured out.

Rich

-- 
Richard Greenwood
richard.greenwood at gmail.com
www.greenwoodmap.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/fwtools/attachments/20090904/f3d73852/attachment.htm