Chris,<br><br>Try to convert the data to some other format using ogr2ogr. GML or Shapefile are very convenient.<br><br><div class="gmail_quote">On Thu, Oct 27, 2011 at 7:17 PM, Chris Green <span dir="ltr"><<a href="mailto:chris.green@ibstv.co.uk">chris.green@ibstv.co.uk</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div link="blue" vlink="purple" lang="EN-GB"><div><p class="MsoNormal">Hi<u></u><u></u></p><p class="MsoNormal">
<u></u> <u></u></p><p class="MsoNormal">I’m trying to get to a point where I can publish an .mdb dataset on Mapserver. Having tried for nearly a week to get OGR and the PGeo driver working on Linux (and not being willing to tackle building the MDB driver which involves compiling GDAL/OGR 1.9), I decided to try and get round my problem by using OGR2OGR to convert my .mdb dataset to MySQL offline, then connect Mapserver to MySQL (something I am doing already).<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">But now I have a different problem. I can open my .mdb file with OGRInfo and OGR2PGR starts off converting the data but then trips up with the error “ERROR 1: Terminating translation prematurely after failed translation of layer ….”. If I tell OGR2OGR to –skipfailures it continues to the end of the file having missed perhaps 60% of the features.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">There is no additional information about the nature of the translation error. Looking at the features in Microsoft Access I see no obvious reason why some should be successfully translated and others should fail. <u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">I realise that MySQL is not the best database for spatial data but I really don’t want to have to change it, and anyway I am not sure whether this problem is caused by OGR2OGR, or by the .mdb file, or by MySQL.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">Does anyone have any suggestions as to how I could establish why these errors occur?<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"><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">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>Best regards,<br>Chaitanya kumar CH.<br>
<br>+91-9494447584<br>17.2416N 80.1426E<br>