3381797 - ODBC connection error to Datasphere's HANA Cloud database

ODBC connection from 3rd Party Tools* to SAP Datasphere's HANA Cloud database fails due:

• [SAP AG][LIBODBCHDB SO][HDBODBC] General error;10 authentication failed: Detailed info for this error can be found with correlation ID 'XXXXXXXXXXXXXXXXXXXXXX'

or

• OLE DB provider "MSDASQL" for linked server "xyz" returned message "[Microsoft][ODBC Driver Manager] Invalid connection string attribute".OLE DB provider "xyz" for linked server "xyz" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed".OLE DB provider "xyz" for linked server "xyz" returned message "[SAP AG][LIBODBCHDB DLL][HDBODBC] General error;10 authentication failed: Detailed info for this error can be found with correlation ID 'xyz'".Msg 7303, Level 16, State 1, Procedure xyz, Line 1 [Batch Start Line 0]Cannot initialize the data source object of OLE DB provider "xyz" for linked server "xyz"

However, same connection works (with same user ID and password) from Database explorer or HANA Cockpit.

*3rd Party Tools: Business Objects server (linux), Linked Server in Microsoft SQL Server 2016 

• SAP HANA Cloud
• SAP Datasphere

ODBC, password, authentication,  , KBA , HAN-CLS-HC , HANA Cloud Services HANA Cloud , DS-DI-CON , Connections , Problem