Selon Hermann Peifer <[email protected]>: > Hi, > > I have been trying to get the PGeo driver working, following the hints > at [0]. > > I have gotten to a partial success in so far that the driver connects to > the mdb and finds the layers and the features [1]. However, the geometry > is not understood, which seems to be related to the "importFromWKT() > failed" error message, which is repeated for each layer [2]. > > Querying individual layers gives an additional "GetFeatureCount() > failed" error, see under [3]. > > I searched on Internet and found a few (older) postings mentioning > similar errors where the WKT string is always truncated to 12 > characters, but nothing could really help me fixing the issue. > > Does anyone know how to fix the issue? (I am using GDAL from trunk, on > 64-bit Debian Linux, unixodbc 2.2.14p2-4, mdbtools 0.5.99.0.6pre1.)
IMHO, you can't. I've spent some time investigating this issues a few months ago and my conclusion was that mdbtools was too buggy (and unmaintained), and in particular not 64bit ready. I tried a few fixes, but finally I gave up. I've developped the MDB driver that relies on the Jackess Java library to workaround mdbtools problems and it works quite well (although not particularly fast due to the invokation of Java code from native code). > > Thanks in advance, Hermann > > [0] http://gdal.org/ogr/drv_pgeo.html > > [1] > > $ ogrinfo --debug on pgeo:mt > PGeo: MDB Tools driver: /usr/lib/libmdbodbc.so.0 > PGeo: MDB Tools driver installed successfully! > PGeo: EstablishSession(mt) > ODBC: SQLConnect(mt) > INFO: Open of `pgeo:mt' > using driver `PGeo' successful. > OGR: GetLayerCount() = 26 > > 1: CoastL > 2: DamL > 3: WatrcrsL > ... > > [2] ERROR 1: importFromWKT() failed on SRS 'GEOGCS["GCS_'. > > [3] > > $ ogrinfo --debug on PGeo:mt CoastL > PGeo: MDB Tools driver: /usr/lib/libmdbodbc.so.0 > PGeo: MDB Tools driver installed successfully! > PGeo: EstablishSession(mt) > ODBC: SQLConnect(mt) > OGR: OGROpen(PGeo:mt/0x8804b0) succeeded as PGeo. > > INFO: Open of `PGeo:mt' > using driver `PGeo' successful. > OGR: GetLayerCount() = 26 > > Layer name: CoastL > Geometry: Unknown (any) > Error at Line : syntax error near ( > ERROR 1: GetFeatureCount() failed on query SELECT COUNT(*) FROM CoastL. > > Feature Count: 11 > Extent: (14.183600, 35.806450) - (14.576150, 36.082430) > Layer SRS WKT: > (unknown) > FID Column = OBJECTID > Geometry Column = Shape > OBJECTID: Integer (0.0) > FCsubtype: Integer (0.0) > gfid: String (0.0) > F_CODE: String (0.0) > ICC: String (0.0) > SN: Integer (0.0) > Shape_Length: Real (0.0) > PGeo: 11 features read on layer 'CoastL'. > ODBC: SQLDisconnect() > > _______________________________________________ > gdal-dev mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/gdal-dev > _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
