ogr2ogr: issue with filename of Pgeo type

[chaitanya]

Reported by pibinko in ​osgeo4w

It seems that ogr2ogr (v 1.5.4-2) does not accept filenames of personal geodatabases with short filenames, or containing numbers in the filename..

a) here is the error: ERROR 1: Unable to initialize ODBC connection to DSN for cipaaaa1, [Microsoft][ODBC Driver Manager] Data source name not found and no default drive r specified FAILURE: Unable to open datasource `Pgeo:cipaaaa1' with the following drivers.

b) I did some tests...it seem the issue related to MDB files..

• with file names less than 3 characters in length - with file names containing a number (any length)..

a.mdb fail ab.mdb fail abc.mdb OK a1.mdb fail abc1.mdb fail abcedfg1.mdb fail

...clearly: I can't say if this is an exhaustive set of tests, but I hope it can help

the issue can be bypassed by renaming the MDB file, so I am giving this a minor priority

regards

[chaitanya]

pibinko,

Could you provide the details of your operating system and possibly your ODBC driver version. I would also appreciate a sample .mdb file. The files I get from net doesn't seem to be recongnised by GDAL (at least in Ubuntu).

[warmerdam]

Chaitanya,

This ticket needs to be addressed on windows. The OGR support for ODBC and particularly MDB files is ideosyncratic at best on non-windows systems. But it is critical that things work smoothly on windows.

[chaitanya]

pibinko,

I was not able to compile the 1.5.4 version Windows. However, I couldn't reproduce the issue with GDAL1.5.0, GDAL1.6 or the trunk version.
Perhaps the problem is with the ODBC driver.
Please tell your current situation with this.