SAP Knowledge Base Article - Preview

3359124 - Error 207 "Invalid column name" accessing a Virtual Table for an MS SQL Server SDA Remote Source

Symptom

Queries that were previously working when run against a virtual table, created for a Microsoft SQL Server remote data source via Smart Data Access (SDA), are now returning errors like below:

[00000]\{000000\}[00/0] 0000-00-00 00:00:00.000000 e FedTrace         odbcaccess.cpp(04002) : {R -1}ODBC error: connected: 1 state: 42S22 code: 207 [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name <COLUMN_NAME>.


Read more...

Environment

SAP HANA, platform edition 2.0

Product

SAP HANA, platform edition 2.0

Keywords

42S22, 207, Invalid column name, MS SQL ODBC, SDA , KBA , HAN-DB-SDA , SAP HANA Smart Data Access , Problem

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.