<br><br><div class="gmail_quote">On Thu, Sep 3, 2009 at 7:58 PM, Simon O'Keefe <span dir="ltr"><<a href="mailto:simon.okeefe@groundtruth.com.au">simon.okeefe@groundtruth.com.au</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi,<br>
<br>
I'm attempting to use ogr2ogr to extract data from a non-spatial<br>
Oracle database and output to a CSV file.<br>
<br>
When I enter:<br>
ogr2ogr -f CSV C:\Temp\CGData<br>
ODBC:gissvr/gis123@pth_prod,gissvr.COMMONGROUND_ADDRESS<br>
<br>
I get:<br>
ERROR 1: No column definitions found for table<br>
'gissvr.COMMONGROUND_ADDRESS', layer not usable.<br>
<br>
I'm trying to follow the syntax example on the ODBC RDBMS page<br>
(<a href="http://www.gdal.org/ogr/drv_odbc.html" target="_blank">http://www.gdal.org/ogr/drv_odbc.html</a>), but it says I need to put the<br>
name of a geometry column in brackets after the table name. How can I<br>
get ogr2ogr to recognise the data source as a non-spatial table (ie,<br>
no geometry column)?<br></blockquote></div><br>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.<br>
<br>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.<br><br>Rich<br clear="all"><br>-- <br>Richard Greenwood<br>
<a href="mailto:richard.greenwood@gmail.com">richard.greenwood@gmail.com</a><br><a href="http://www.greenwoodmap.com">www.greenwoodmap.com</a><br>