Impala ODBC connectivity error

[#1]

Hi, 

I have installed Cloudera Impala ODBC 64-bit driver on AIX platform. I have configured DSN in ".odbc.ini" along with authentication( used "Kerboros" auth) info.

I have exported ODBCINI and ODBCSYSINI variables in the environment. I am using Ab Initio to test the Impala database connection and getting below error -

ABINITIO(DB16000): ODBC Error
ABINITIO(DB16000): SQLCODE: 11560
ABINITIO(DB16000): SQLSTATE: HY000
ABINITIO(DB16000): MESSAGE: [unixODBC][Cloudera][ODBC] (11560) Unable to locate SQLGetPrivateProfileString function.
ABINITIO(DB00067): Current DB Environment:

Please advise on above error.

Thanks

[#2]

Can you please provide cloudera.impalaodbc.ini file for review?

[#3]

Can you please post the solution to this issue? I'm also facing the same while trying to connect to Impala using R

[#4]

anyone has any update on the issue. We are trying to connect using impala odbc driver from AIX and facing the error.

ABINITIO(DB16000): SQLCODE: 1170
ABINITIO(DB16000): SQLSTATE: HY000
ABINITIO(DB16000): MESSAGE: [Cloudera][DriverSupport] (1170) Unexpected response received from server. Please ensure the server host and port specified for the connection are correct.
ABINITIO(DB00067): Current DB Environment:

[#5]

@manikala  as this is an older post, you would have a better chance of receiving a resolution by starting a new thread. This will also be an opportunity to provide details specific to your environment that could aid others in assisting you with a more accurate answer to your question. You can link this thread as a reference in your new post.