<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><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 class="yshortcuts" id="lw_1251401915_0">Geodatabase</span> (.mdb) on <span class="yshortcuts" id="lw_1251401915_1">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 target="_blank" href="http://gdal.org/ogr/drv_pgeo.html"><span class="yshortcuts" id="lw_1251401915_2">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 id="ctl00_cphMain_BodyContent"><code>ogr2ogr -f "<span class="yshortcuts" id="lw_1251401915_3">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); cursor: pointer;" class="yshortcuts" id="lw_1251401915_4">2.6.28</span>-14-server - <span class="yshortcuts" id="lw_1251401915_5">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;"><style>
<!--
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman";}
_filtered {margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{}
-->
</style><span style="font-size: 12pt;"> unixodbc libmdbodbc</span> gdal-bin <style>
<!--
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman";}
_filtered {margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{}
-->
</style>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 class="yshortcuts" id="lw_1251401915_6">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); cursor: pointer;" class="yshortcuts" id="lw_1251401915_7">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></body></html>