Mike,<br><br>The packages provided by the ubuntu repos may not be the latest. Despite the fact that PGeo driver has been not as reliable on Linux as on Windows, it might help if you installed the latest versions.<br><br>If you are willing to going through all this trouble, then you might as well just compile the latest odbc library and then compile the gdal library against it. Look at <a href="http://trac.osgeo.org/gdal/wiki/BuildingOnUnix">http://trac.osgeo.org/gdal/wiki/BuildingOnUnix</a> and make sure to use the option "--with-odbc=<path>" with the program ./configure .<br>
<br><div class="gmail_quote">On Fri, Aug 28, 2009 at 1:13 AM, Mike Hapner <span dir="ltr"><<a href="mailto:mikehapner@yahoo.com">mikehapner@yahoo.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;">
<div><div style="font-family: arial,helvetica,sans-serif; font-size: 10pt;"><div>Short version:<br>Trying to get ogr2ogr (and ogrinfo) to work with an ESRI Personal <span>Geodatabase</span> (.mdb) on <span>Linux</span>.<br>
<br>-----------------------------------------------------------------------------------------------------------------------------------------<br><br>I've
done quite a bit of research and am pulling my hair out, so I'd love it
if someone can point out the one or more thing(s) that I'm doing wrong.<br><br>I've mainly been trying to get the scenario on this page to work: <a href="http://gdal.org/ogr/drv_pgeo.html" target="_blank"><span>http://gdal.org/ogr/drv_pgeo.html</span></a><br>
<br>I'm
trying to push an ESRI Personal Geodatabase called geonames.mdb into a
Postgres/PostGIS database. I can do this fine with ogr2ogr on
windows...but cannot for the life of me get it to work on Linux. (For
example -- in windows... <span><code>ogr2ogr -f "<span>PostgreSQL</span>"
PG:"host=192.168.23.23 user=someuser dbname=poi password=somepassword
port=5432" S:\GISData\Geonames.mdb -a_srs EPSG:26986
</code></span>works great)<br><br>My environment:<br>- Linux <span style="border-bottom: 1px dashed rgb(0, 102, 204);">2.6.28</span>-14-server - <span>Ubuntu</span> 9.04(64bit)<br>- Postgres/PostGIS<br>- Installed the following packages with apt-get<br>
<div style="font-family: arial,helvetica,sans-serif; font-size: 10pt;"><span style="font-size: 12pt;"> unixodbc libmdbodbc</span> gdal-bin mdbtools<br>-- Note: I installed gdal-bin to get the ogr utilities because I couldn't get FWTools installer to work.... <br>
<br><br>/etc/odbcinst.ini --- Note that the file in the driver line exists... and has read permissions<br> [<span>Microsoft Access Driver</span> (*.mdb)]<br> Description = MDB Tools ODBC drivers<br> Driver = /usr/lib/libmdbodbc.so.0 <br>
Setup =<br> FileUsage = 1<br> CPTimeout =<br> CPReuse =<br><br><br><br>~/.odbc.ini <br>[geonames]<br>Description = Sample PGeo Database<br>Driver = Microsoft Access Driver (*.mdb)<br>Database =
/mnt/data/gis/testgis/geonames.mdb<br>Host = <br>Port = <br>User =<br>Password =<br>Trace = Yes<br>TraceFile = /mnt/data/gis/testgis/odbc.log<br><br><br><br>Things that work correctly:<br>
$mdb-tables -1 geonames.mdb # proves to me that mdbtools is properly installed and can see the tables inside the <span style="border-bottom: 1px dashed rgb(0, 102, 204);">mdb file</span><br>GDB_ReleaseInfo<br>GDB_FeatureDataset<br>
GDB_ObjectClasses<br>...<br>...<br>...<br><br>$ogrinfo
abc123.shp # proves to me that ogrinfo (from gdal-bin) is
installed and can at least open a SHP file I had laying around<br>INFO: Open of `abc123.shp'<br> using driver `ESRI Shapefile' successful.<br>1: abc123 (3D Point)<br><br>$ogr2ogr -f "KML" abc123.kml abc123.shp #
This creates kml of the shp file... perfect.<br><br><br>The problem is when I try to get it to open the geonames connection...<br>--------------------------------------------------------------------------------------------------------------<br>
$ ogrinfo PGeo:geonames<br>ERROR 1: PGeo: MDB Tools driver not found!<br><br>ERROR 1: Unable to install MDB driver for ODBC!<br><br>ERROR 1: PGeo: MDB Tools driver not found!<br><br>ERROR 1: Unable to install MDB driver for ODBC!<br>
<br>FAILURE:<br>Unable to open datasource `PGeo:geonames' with the following drivers.<br><br>---------------------------------------------------------------------------------------------------------------<br>$ ogr2ogr -f "KML" abc123.kml PGeo:geonames.mdb<br>
ERROR 1: PGeo: MDB Tools driver not found!<br><br>ERROR 1: Unable to install MDB driver for ODBC!<br><br><br>I know this is kinda long, but I didn't want to get yelled at for not doing my homework and not giving enough info...
Looking forward to hearing back!</div></div></div></div><br>_______________________________________________<br>
gdal-dev mailing list<br>
<a href="mailto:gdal-dev@lists.osgeo.org">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></blockquote></div><br><br clear="all"><br>Best regards,<br>-- <br>Chaitanya kumar CH.<br>