SAP Knowledge Base Article - Preview

1319383 - Exception: DBD, [Microsoft] [ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression while creating a Desktop Intelligence report on MS Access database.

Symptom

  • While creating Desktop Intelligence report based on MS Access database and using ODBC connection below mentioned error message is displayed.
  • Exception: DBD, [Microsoft] [ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression.
  • Following SQL is generated.

    • Select * from TABLE_A INNER JOIN TABLE_B ON (TABLE_B.ID1 =TABLE_A.ID1)
    LEFT OUTER JOIN TABLE_C ON (TABLE_C.ID2 = TABLE_A.ID2)
    LEFT OUTER JOIN TABLE_D ON (TABLE_D.ID3 = TABLE_A.ID3)


Read more...

Product

SAP BusinessObjects Business Intelligence platform R2

Keywords

Missing, operator, MS Access. , KBA , BI-RA-DKI , Obsolete - Desktop Intelligence , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.