English

Error: -2147216086 (FDO_E_SE_ATTR_NOEXIST)

Error Message

Opening an ADO recordset based on a join between two ArcSDE tables, using the ESRI OLE DB provider, fails with the following FDO error:

-2147216086 (FDO_E_SE_ATTR_NOEXIST)

Cause

This will occur if the SQL statement used to open the record set includes the SHAPE.AREA or SHAPE.LEN columns. Although these columns are present when the data is previewed in ArcCatalog/ArcMap, these fields are maintained in a separate table and do not form part of the base tables.

Solution or Workaround

Construct an SQL statement that does not include these columns when opening a recordset based on a join between two ArcSDE tables.