SAP Knowledge Base Article - Preview

2657948 - MS Access shows "#Name?" as character column values on a link table - SDK for SAP ASE

Symptom

  • After creating a link table pointing to ASE, when you open the link table, MS Access shows "#Name?" as character column values.
  • ODBC Trace shows that SQLGetData() with SQL_C_WCHAR fails due to "Invalid character conversion. (30062)".
  • This problem occurs only if ASE's charset is utf8 and ODBC Driver's charset property is "ClientDefault" and clientcharset property is not "utf8".


Read more...

Environment

  • SAP ASE ODBC Driver 15.7
  • SAP ASE ODBC Driver 16.0
  • Microsoft Windows x86 (32-bit)
  • Microsoft Windows x64 (64-bit)
  • Microsoft Access
  • ASE's charset is utf8 and ASE's language is japanese
  • ODBC Driver's charset property is "ClientDefault" and clientcharset property is such as "sjis" or "eucjis".

Product

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

Keywords

ODBC, MS Access, ODBC-call failed, sjis, utf8, #Name?, SQLGetData, SQL_C_WCHAR, Invalid character conversion, 30062, #815494 , KBA , BC-SYB-SDK , SDK , 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.