Skip to Content
Former Member
Mar 02, 2017 at 08:58 AM

MSSQL Linked Server with HANA data type error


Hello everybody,

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?

Kind regards,

Dimitris Theotokatos