SAP Knowledge Base Article - Preview

2163417 - ODBC: Incorrect syntax near the keyword 'where' or Incorrect syntax near 'from' error when sending query with database object in double quotes - SAP SDK

Symptom

  • Send SQL to ASE results in error when using database object in double quotes
  • Error:
     
    • [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Incorrect syntax near the keyword 'where'. 
       
    • or
       
    • [SAP][ASE ODBC Driver][Adaptive Server Enterprise]Incorrect syntax near 'from'.

Read more...

Environment

  • SAP Sybase Software Developers Kit (SDK) 15.7
  • SAP Software Developers Kit (SDK) for Adaptive Server Enterprise (ASE) 16.0
  • Adaptive Server Enterprise ODBC Driver by Sybase
  • AIX 32 bit
  • AIX 64 bit
  • HP-UX on IA64 32 bit
  • HP-UX on IA64 64 bit
  • Linux on IA32 32 bit
  • Linux on x86_64 64 bit
  • Linux on Power 32 bit
  • Linux on Power BE 64 bit
  • Solaris on SPARC 32 bit
  • Solaris on SPARC 64 bit
  • Solaris x86 32 bit
  • Solaris x86-64 64 bit
  • Microsoft Windows x86 (32-bit)
  • Microsoft Windows x64 (64-bit)

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise SDK 16.0 ; Sybase SDK all versions ; Sybase Software Developer Kit 15.7

Keywords

PC Client, unixODBC, OCS   , KBA , BC-SYB-SDK , SDK , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

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

Search for additional results

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