Symptom
You want to use SAP HANA database as a datasource for a MS SQL Server database through Linked Servers.
Please be aware that MS SQL linked server connections to SAP HANA are not officially supported. Following the below steps might work but SAP does not provide support for problems caused by the usage of MSDASQL provider while connecting to HANA, which maybe bad performance or OPENTEXT SQL errors but is not limited to this problems. As an alternative you can use SAP HANA Smart Data Access which is explaind in SAP Note 2180119.
Read more...
Environment
- SAP HANA database;
- MS SQL Server 2008 and higher;
Product
Keywords
mssql, linked, server, datasource, odbc, oledb, sql, connection, data, source, how, to, howto, setup, configure, microsoft, sql, server, studio, query, Msg 7356, msdasql, inconsistent metadata , KBA , HAN-DB-CLI , SAP HANA Clients (JDBC, ODBC) , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.