View Error - Linked Server

Copper Contributor

Hello,

 

 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=192.168.100.100:30013;databaseName=SBO_HANA

 

Thank you.

 

camachomjgabriel_1-1696966212983.png

 

 

 

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