View Error - Linked Server

Copper Contributor



 I  have this situation . Can you help me please?  It's a linked server from  SAP HANA DB with MS SQL 2022.

I´m using ODBC:

ODBC; PROVIDER=HDBODBC;dsn=HANA;UID=HanaAdmin;PWD=HanaDB1234;serverNode=;databaseName=SBO_HANA


Thank you.






2 Replies
? As the message says "can't find column" ??
Sorry, but with that less on information it's difficult to guess.

Hi@olafhelper , 

The message is : Cannot find either column "DocDate" or the user-defined function or aggregate "DocDate.ToString" or the name is ambiguous.

I'm trying to create a SQL View.

Thanks for You help