SAP Knowledge Base Article - Preview

3465865 - DSConnectionmanage not able to create ODBC connection to SAP IQ - SAP Data Services

Symptom

testConnection: run '/opt/sap/dataservices/utilities/UNIXDBDriverManager/scripts/connection_test.sh -S'<DSN name>' -U'XXXXX' -P'***' -N'SYBASE IQ' -testrepo'
(14.3) CON-120301: Initialization
Database connection failed to allocate HENV, required to perform any ODBC operation. This usually occurs due to insufficient memory.
testConnection: failure output ''
ERROR: connection test failed!

If running the test connection through unix odbc manager
isql <DSN name> <username> <password> -v
[IM004][unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed
[ISQL]ERROR: Could not SQLConnect


Read more...

Environment

Data Services 4.2, 4.3
SAP Sybase IQ 16.1
linux

Product

SAP BusinessObjects Business Intelligence platform 4.3

Keywords

upgrade, BODS, connection , KBA , EIM-DS-SVR , Administration/Server , BC-SYB-IQ , Sybase IQ , 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.