[mapserver-users] PGeo (Personal Geodatabases) options under Linux
Dan Little
danlittle at yahoo.com
Sun Nov 29 19:06:18 PST 2009
not that this answers the problem... but is there any reason this cannot be exported to a shapefile and then served with mapserver?
----- Original Message ----
> From: Chuck Jungmann <chuck at cpjj.net>
> To: Stephen Woodbridge <woodbri at swoodbridge.com>
> Cc: mapserver-users at lists.osgeo.org
> Sent: Fri, November 27, 2009 5:17:03 PM
> Subject: Re: [mapserver-users] PGeo (Personal Geodatabases) options under Linux
>
> I've read that page several times. I have also built MDBTools, unixODBC
> and GDAL from CVS sources and applied patches, etc, so I could try to
> trace execution to the errors. What I've found are instances where the
> code ultimately ends up in an empty function that simply returns
> SQL_SUCCESS or SQL_OK or whatever without doing anything. That seems to
> be why MDBTools has trouble with "SELECT COUNT(*) FROM xxx" and why it
> can't find a primary key.
>
> While I can see that these database features are not working, it's also
> possible that they are not necessary. I'm wondering if anyone has had
> success, either despite these errors, or by not encountering these
> errors, in which case I may find some success if I can duplicate their
> environment.
>
> Thanks for the quick reply,
> Chuck Jungmann
>
> On Fri, 2009-11-27 at 18:00 -0500, Stephen Woodbridge wrote:
> > Chuck Jungmann wrote:
> > > I have a Personal Geodatabase (PGeo) from which I would like to display
> > > layers in MapServer on Ubuntu 9.04. I have been fighting with MDBTools,
> > > unixODBC, and GDAL for what seems like forever. The ogrinfo and isql
> > > fail with Segmentation Faults.
> > >
> > > I have two questions:
> > >
> > > 1. Has anyone successfully used a PGeo file to display maps on MapServer
> > > under Linux? Perhaps my efforts were doomed from the start.
> > >
> > > 2. Since GDAL is using ODBC to read the MDB file, would using ODBC to
> > > access MySQL be a transparent replacement, assuming I copy all of the
> > > tables and indexes from the PGeo file to MySQL? Has anyone done this?
> > > I don't want to waste a lot of time on this if it's another dead end.
> >
> > Chuck,
> >
> > There was a recent thread related to these problems on the GDAL list.
> > Frank posted the follow link and commented that there are also probable
> > some open bugs. Evidently, the mdbtools are not well supported and buggy
> > which makes using them problematic.
> >
> > http://trac.osgeo.org/gdal/wiki/mdbtools
> >
> > Check out this thread on the gdal-dev archives:
> > [gdal-dev] mdb to shape conversion: no geometry exported
> >
> > -Steve
> >
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
More information about the MapServer-users
mailing list