SAP Knowledge Base Article - Preview

3608533 - Configuring DSN connection to Google BigQuery via DSConnectionManager.sh fails with error 'Driver's SQLAllocHandle on SQL_HANDLE_HENV failed' - SAP Cloud Integration for data services

Symptom

  • Follow GoogleBigQuery ODBC to configure DSN connection to Google BigQuery via DSConnectionManager.sh fails in agent Linux server.
  • Error: Initialization ODBC call <SQLConnect> to connect database <XXX> failed with error: <ODBC call <SQLConnect> for data source <ibp_atenea_consume> failed: <[unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed>. Notify Customer Support.>. Use the ODBCDriverSelector (Windows) or DSConnectionManager.sh (UNIX) utility in LINK_DIR/bin to configure the correct version of the driver. If the problem still exists after selecting the correct version of the driver, notify Customer Support.


Read more...

Environment

  • SAP Cloud Integration for data services
  • Google BigQuery

Product

SAP Cloud Integration for data services 1.0

Keywords

CIDS, GBQ, Google BigQuery, DSConnectionManager, SQLAllocHandle, SQL_HANDLE_HENV, LINK_DIR, correct version, ODBC , KBA , LOD-HCI-DS , HANA Cloud Integration for Data Services , LOD-HCI-DS-AGNT , On-Premise Agent, Connectivity, Task Run errors , Problem

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.