Gregor,<br><br>Your error message should be resolved by an upgrade.<br><br>Use the --formats option with ogrinfo to see the status of the ODBC driver.<br><br>GDAL/OGR's ODBC driver is currently readonly. Refer to <a href="http://www.gdal.org/ogr/drv_odbc.html">http://www.gdal.org/ogr/drv_odbc.html</a> and <a href="http://www.gdal.org/ogr/drv_pgeo.html">http://www.gdal.org/ogr/drv_pgeo.html</a> for more details.<br>
<br><div class="gmail_quote">On Thu, Feb 4, 2010 at 5:40 AM, Gregor at HostGIS <span dir="ltr"><<a href="mailto:gregor@hostgis.com">gregor@hostgis.com</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;">
Hey all. I've been asked to set up support for pseudo-spatial data via ODBC. So far, I've not had any luck. We're using this as our starting point:<br>
<a href="http://mapserver.org/input/vector/VirtualSpatialData.html" target="_blank">http://mapserver.org/input/vector/VirtualSpatialData.html</a><br>
<br>
But I get this...<br>
<br>
$ ogrinfo ODBC:gregor/mosheh@testPgSQL table<br>
*** glibc detected *** free(): invalid next size (fast): 0x0000000000505520 ***<br>
Aborted<br>
<br>
So my very first questions are a) whether the tricks described in that document has ever been considered production-stable, and b) whether upgrading from GDAL/OGR 1.5.4 to 1.6.3 is likely to help. Then of course (c) would be "So what AM I doing wrong?" :)<br>
<br>
The OS is Linux, and I have installed unixODBC and drivers for PostgreSQL (bundled with unixODBC) and MySQL (MySQL Connector). I then rebuilt GDAL/OGR 1.5.4 including --withodbc=/usr/local/unixODBC<br>
<br>
My odbc.ini is as follows:<br>
<br>
[testPgSQL]<br>
Description = Test to Postgres<br>
Driver = PostgreSQL<br>
Database = MY_DATABASE<br>
Servername = MY_HOSTNAME<br>
Port = 5432<br>
Protocol = 8.2<br>
ReadOnly = No<br>
RowVersioning = No<br>
ShowSystemTables = No<br>
ShowOidColumn = No<br>
FakeOidIndex = No<br>
ConnSettings =<br><font color="#888888">
<br>
<br>
-- <br>
HostGIS, Open Source solutions for the global GIS community<br>
Greg Allensworth - SysAdmin, Programmer, GIS Person, Security<br>
Network+ Server+ A+ Security+ Linux+<br>
PHP PostgreSQL MySQL DHTML/JavaScript/AJAX<br>
<br>
"No one cares if you can back up — only if you can recover."</font><div><div></div><div class="h5"><br>
_______________________________________________<br>
gdal-dev mailing list<br>
<a href="mailto:gdal-dev@lists.osgeo.org" target="_blank">gdal-dev@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/gdal-dev" target="_blank">http://lists.osgeo.org/mailman/listinfo/gdal-dev</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Best regards,<br>Chaitanya kumar CH.<br>/tʃaɪθənjə/ /kʊmɑr/ <br>+91-9848167848<br>17.241582N 80.142635E<br>