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


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.



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


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


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 for Me (Login required).

Search for additional results

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