[gdal-dev] ogr and mdb conversion

[Chaitanya kumar CH]

Chris,

Try to convert the data to some other format using ogr2ogr. GML or Shapefile
are very convenient.

On Thu, Oct 27, 2011 at 7:17 PM, Chris Green <chris.green at ibstv.co.uk>wrote:

> Hi****
>
> ** **
>
> 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).****
>
> ** **
>
> 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.****
>
> ** **
>
> 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. ****
>
> ** **
>
> 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.****
>
> ** **
>
> Does anyone have any suggestions as to how I could establish why these
> errors occur?****
>
> ** **
>
> ** **
>
> ** **
>
> Chris****
>
>  ****
>
> ** **
>
> ** **
>
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev
>



-- 
Best regards,
Chaitanya kumar CH.

+91-9494447584
17.2416N 80.1426E
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/gdal-dev/attachments/20111027/f99704d4/attachment.html