SAP Knowledge Base Article - Preview

3098659 - Requesting datetime column information with sp_odbc_columns returns ODBC 2.0 standard 11 for DATA_TYPE instead of ODBC 3.0 standard 93 - SDK for SAP ASE

Symptom

SQL Server has a new proxy table system in version 2019.  This causes issues with a datetime column.
Error :: Msg 110813, Level 16, State 1, Line 13
   Unknown type Timestamp at GetSqlTypeId.

This error appears because when getting the column information we return 11 which isn't supported any longer. It is expecting 93.


Read more...

Environment

  • SAP Sybase Software Developer Kit (SDK) 15.7 SPxxx
  • SAP Adaptive Server Enterprise (ASE) Software Developer Kit (SDK) 16.0 SPxxx PLxx
  • Adaptive Server Enterprise ODBC Driver by Sybase
  • odbc

Product

SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise SDK 16.0

Keywords

KBA , BC-SYB-SDK , SDK , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error

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.