cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
YelloBlack Frequent Visitor
Frequent Visitor

UNABLE TO CONNECT - ODBC

"UNABLE TO CONNECT"

 

Encountered an error while trying to connect to ODBC

 

Details: "ODBC: ERROR [HY000] [Hortonworks][Hardy] (34) Error from server: SASL(-1): generic failure: GSSAPI Error: Unspecified GSS failure.  Minor code may provide more information (Internal credentials cache error).
ERROR [HY000] [Hortonworks][Hardy] (34) Error from server: SASL(-1): generic failure: GSSAPI Error: Unspecified GSS failure.  Minor code may provide more information (Internal credentials cache error)."

 

I am able to sucssefully test the connection from Hortonworks Hive ODBC Driver DSN Setup

1 ACCEPTED SOLUTION

Accepted Solutions
YelloBlack Frequent Visitor
Frequent Visitor

Re: UNABLE TO CONNECT - ODBC

Yay!

 

I am able to connect now the issue was with version of powerBi .  I downloaded 64bit and works well.

 

 

Thanks

YB

12 REPLIES 12
Moderator v-yuezhe-msft
Moderator

Re: UNABLE TO CONNECT - ODBC

Hi @YelloBlack,

Firstly, ensure that you download the latest version of Hortonworks Hive ODBC Driver.

Secondly, in the DSN setup window, enable “Use only SSPI” under Advanced Options, then check if the error still occurs.

Thirdly, follow the steps in this blog to use “User Name” Mechanism to connect to Hive and check if it is successful.

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
YelloBlack Frequent Visitor
Frequent Visitor

Re: UNABLE TO CONNECT - ODBC

Hi @v-yuezhe-msft,

 

Thanks for your response.

 

I am using version Hortonworks Hive ODBC Driver 2.5 Version.

 

For point two i get an error

FAILED!

[Hortonworks][Hardy] (34) Error from server: SASL(-1): generic failure: Failed to initialize security context: The specified target is unknown or unreachable

 

 

For point three i get an error.

[Hortonworks][ThriftExtension] (2) Error occured during authentication.

Can i not connect using "Kerberos" instead of "User Name" Athentication Mechanism  ?

 

 

Regards

YB

Moderator v-yuezhe-msft
Moderator

Re: UNABLE TO CONNECT - ODBC

Hi @YelloBlack,

You can use Kerberos authentication. The first error is related to your Kerberos settings, please follow the instructions in this article to configure Kerberos authentication.

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
YelloBlack Frequent Visitor
Frequent Visitor

Re: UNABLE TO CONNECT - ODBC

Hi @v-yuezhe-msft

 

Successfully connected to Hortonworks Hive ODBC Driver DSN Setup (MIT Kerberos) with message

 

SUCCESS!

Successfully connected to data source!

ODBC Version: 03.80
Driver Version: 2.1.7.1010
Bitness: 32-bit
Locale: en_US

 

 

When using the same System DSN to connect on powerBI i get following error -

 

Unable to connect

 

We enountered an error while trying to connect.

 

Details: "ODBC: ERROR [HY000] [DSI] The error message HardyHiveError could not be found in the en-US locale. Check that C:\Program Files (x86)\Hortonworks Hive ODBC Driver\ErrorMessages\en-US\HiveODBCMessages.xml exists.
ERROR [HY000] [DSI] The error message HardyHiveError could not be found in the en-US locale. Check that C:\Program Files (x86)\Hortonworks Hive ODBC Driver\ErrorMessages\en-US\HiveODBCMessages.xml exists."

 

 

I am using 32bit powerBi and hortonworks hive driver setup.

 

 

 

Regards,

YB

Moderator v-yuezhe-msft
Moderator

Re: UNABLE TO CONNECT - ODBC

Hi @YelloBlack,

Please follow the instructions in the blog below to troubleshoot the above error message. The configuration file in your scenario is hortonworks.hiveodbc.ini .

https://archive.sap.com/discussions/message/15565579?tstart=0#15565579

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
YelloBlack Frequent Visitor
Frequent Visitor

Re: UNABLE TO CONNECT - ODBC

Hi @v-yuezhe-msft

 

I am back to intial error of -

 

" Details: "ODBC: ERROR [HY000] [Hortonworks][Hardy] (34) Error from server: SASL(-1): generic failure: GSSAPI Error: Unspecified GSS failure.  Minor code may provide more information (Internal credentials cache error).
ERROR [HY000] [Hortonworks][Hardy] (34) Error from server: SASL(-1): generic failure: GSSAPI Error: Unspecified GSS failure.  Minor code may provide more information (Internal credentials cache error)."

 

 

My machine is 64bit windows 7 Enterprise

I have both 64bit and 32bit Hortonworks Hive ODBC Drivers(latest version)

I have PowerBi 32bit

 

Should i get 64bit powerbi? could that be the issue?

 

Thanks for all the support.

 

 

 

YelloBlack Frequent Visitor
Frequent Visitor

Re: UNABLE TO CONNECT - ODBC

Yay!

 

I am able to connect now the issue was with version of powerBi .  I downloaded 64bit and works well.

 

 

Thanks

YB

edejes2
Advisor

Re: UNABLE TO CONNECT - ODBC

Hello, 

 

I am having same issues can you please provided me with some guidance. 

 

Regards!

Erich Dejesus

 

 

 

YelloBlack Frequent Visitor
Frequent Visitor

Re: UNABLE TO CONNECT - ODBC

Hi @edejes2,

 

Could you please provide further details to your issue. Like what version of PowerBI are you using, what is the error message or any other details that you might think would be useful.

 

I will try to help. Thanks!

 

 

YB