Chris,<br><br> There is also another route that may work for PGeo, <a href="http://www.gdal.org/ogr/drv_mdb.html" target="_blank">http://www.gdal.org/ogr/drv_mdb.html</a> I recently built that on Ubuntu but have not used it yet. It looks like you are close on the other route though. <br>
<br>HTH, Eli<br><br><div class="gmail_quote">On Mon, Oct 24, 2011 at 5:35 AM, Chris Green <span dir="ltr"><<a href="mailto:chris.green@ibstv.co.uk" target="_blank">chris.green@ibstv.co.uk</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div link="blue" vlink="purple" lang="EN-GB"><div><p class="MsoNormal">Hi List<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">I’m hoping someone can help me make ogr work under Linux with the PGeo driver, so I can read an ESRI Personal Database .mdb file into Mapserver. I can see from old posts that the basic problem is that MDBTools is a bit ‘flaky’ and needs a DSN based connection rather than connecting direct to the .mdb data.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">I have been trying to follow the instructions in <a href="http://www.gdal.org/ogr/drv_pgeo.html" target="_blank">http://www.gdal.org/ogr/drv_pgeo.html</a> . Having installed unixODBC and MDBTools, I configured the odbcinst.ini and odbc.ini files as suggested and it seems that I have partial success because when I define my datasource in odbc.ini like so:<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New"">[my_pgeo]<u></u><u></u></span></p><p class="MsoNormal" style="text-autospace:none">
<span style="font-size:10.0pt;font-family:"Courier New"">Description = Sample PGeo Database<u></u><u></u></span></p><p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier New"">Driver = Microsoft Access Driver (*.mdb)<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New"">Database = /var/www/vhosts/<a href="http://mydomain.com/httpdocs/data/test.mdb" target="_blank">mydomain.com/httpdocs/data/test.mdb</a><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New"">then the command ogrinfo </span> PGeo:my_pgeo results in the following:<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">INFO: Open of ‘PGeo:my_pgeo’ using driver ‘PGeo’ successful. <u></u><u></u></p><p class="MsoNormal"><span style="background:yellow">Error: syntax error at line:2 col:0</span><u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">I can’t figure out what or where this syntax error can be. I feel that I am quite close to success but don’t know how to move forward from here. Can anyone point me in the right direction please?<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p><font color="#888888"><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">Chris <u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p></font></div></div><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></blockquote></div><br><br clear="all"><br><br><br>