SAP Knowledge Base Article - Preview

3273240 - Connection option to HANA using Interactive SQL (DBISQL) from command line is incorrect - HDL

Symptom

In Procedure section in the below document, DBISQL command line syntax is written as follow:

Interactive SQL (dbisql) Context-Sensitive Help for Data Lake Relational Engine
- Connect to SAP HANA Database Using Interactive SQL from a Command Line

dbisql -hana -nogui -c "USER=<username>;PWD=<password>;HOST=<sql_endpont>:443"

However a part of the above syntax is incorrect.

sample)

$ dbisql -hana -nogui -c "USER=DBADMIN;PWD=MyPassword;HOST=ff294b1c-5817-4a50-9f74-a44b5270e222i.hana.prod-eu12.hanacloud.ondemand.com:443"
Could not connect to the database.
: authentication failed
SQLCODE=10, ODBC 3 State="28000"

(Not Connected)>


Read more...

Environment

SAP HANA Cloud, Data Lake

Product

SAP HANA Cloud all versions

Keywords

Data Lake, dbisql, PWD, PASSWORD, -nogui, authentication failed , KBA , HAN-CLS-HC-HDL , HANA Cloud HANA Data Lake , Known Error

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.