I successfully managed to use Linked Server function from SQL Server Management Studio to link MSSQL Server with HANA Server.
The problem is when I try to select multiple values from a table/view and in these values a NCLOB data type from HANA is include there is an SQL error saying
"Error converting data type DBTYPE_DBTIMESTAMP to datetime2."
but when I select this value alone there is no problem. I tried to cast NCLOB value as nvarchar(max) with no success.
What can I do to fix this problem?