Forum Discussion

YelloBlack's avatar
YelloBlack
Frequent Visitor
9 years ago
Solved

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

Need Help
  • YelloBlack's avatar
    YelloBlack
    9 years ago

    Yay!

     

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

     

     

    Thanks

    YB

12 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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

    • YelloBlack's avatar
      YelloBlack
      Frequent Visitor
      9 years ago

      Hi Anonymous,

       

      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        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