[mapserver-users] PGeo (Personal Geodatabases) options under Linux

[Stephen Woodbridge]

Dan Little wrote:
> not that this answers the problem... but is there any reason this
> cannot be exported to a shapefile and then served with mapserver?

Good question. I think you would have to do that on a Windows box 
because the MDBTools on Linux is just not up to the task. If you could 
export it on Linux then you could also probably serve it directly via 
mapserver and ogr.

-Steve W

> ----- 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
> 
> 
> 
>