Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Unable to locate SQLGetPrivateProfileString function.

Unable to locate SQLGetPrivateProfileString function.

New Contributor

Hi ,

 

 

i am getting below given error while connecting to cloudera hive using cloudera hive odbc driver.

 

[Cloudera][ODBC] (11560) Unable to locate SQLGetPrivateProfileString function.[DataDirect][ODBC lib] Driver's SQLSetConnectAttr failed
Database driver error...
Function Name : Connect
Database driver error...
Function Name : Connect
Database Error: Failed to connect to database using user [hive] and connection string [Cloudera_Hive].]

 

ODBC.ini file entry:-

[ODBC Data Sources]
Sample Cloudera Hive DSN 32=Cloudera Hive ODBC Driver 64-bit
[Cloudera_Hive]
Driver=/opt/cloudera/hiveodbc/lib/64/libclouderahiveodbc64.so
HOST=52.25.153.146
PORT=10000
Schema=default
HiveServerType=2
HS2AuthMech=2
FastSQLPrepare=0
UseNativeQuery=0
UserName=hive
Trace=Yes
TraceFile=/tmp/odbc.log

 

I have also configured the below given variable in .profile path.


LD_PRELOAD=/Informatica/ODBC7.1/lib/libodbcinst.so

 

but still i am getting the same issue.

so please provide the resolution for the same.

 

regards

sarvesh