SDE driver does not recognize table anymore

[bartvde]

This used to work in GDAL 1.5 but does not work in 1.6.1 or 1.6.2.

A ogrinfo call like the following:

ogrinfo SDE:geodatabase.ad.rws.nl,5151,PGPR,RWS_LEZEN,****,WEGEN.WEGEN_NWB_LIGHT

lists all tables and not only the one specified.

The problem is in ogrsdedatasource.cpp, where the else clause which lists all spatial tables was moved down, so it now corresponds to a different if clause.

old code:

    if ( CSLCount( papszTokens ) == 6 && *papszTokens[5] != '\0' )
    {
        OpenSpatialTable( papszTokens[5] );
    }
    else
    {
        EnumerateSpatialTables();
    }

new code:

    else if ( CSLCount( papszTokens ) == 8 && *papszTokens[7] != '\0' )
    {
        ....
    }
    else
    {
        CPLDebug("OGR_SDE", "Setting version to SDE.DEFAULT");
        nSDEErr = SetVersionState("SDE.DEFAULT");
        EnumerateSpatialTables();
        if (!nSDEErr)
        {
            // We've already set the error
            CSLDestroy( papszTokens );
            return FALSE;
        }

    }

There is a workaround for this issue, by opening the dataset in read-only mode and specifying the version (which causes the else loop not to be reached):

[bart@hades nappub_svn]$ ogrinfo -ro SDE:geodatabase.ad.rws.nl,5151,PGPR,RWS_LEZEN,****,WEGEN.WEGEN_NWB_LIGHT,SDE.DEFAULT INFO: Open of `SDE:geodatabase.ad.rws.nl,5151,PGPR,RWS_LEZEN,***,WEGEN.WEGEN_NWB_LIGHT,SDE.DEFAULT'

using driver `SDE' successful.

1: WEGEN.WEGEN_NWB_LIGHT

[Jukka Rahkonen]

Hi bartvde, five years have passed by. Could you check if recent GDAL versions can recognize SDE tables and hopefully close the ticket?

[bartvde]

I am not so involved anymore in GDAL so I have no access to ArcSDE anymore so I'll close this.