Forum Discussion

camachomjgabriel's avatar
camachomjgabriel
Copper Contributor
Oct 10, 2023

View Error - Linked Server

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.

 

 

 

 

  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    Oct 11, 2023
    ? As the message says "can't find column" ??
    Sorry, but with that less on information it's difficult to guess.
    • camachomjgabriel's avatar
      camachomjgabriel
      Copper Contributor
      Oct 11, 2023

      Hiolafhelper , 

      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

Resources