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: Un...
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

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

      • YelloBlack's avatar
        YelloBlack
        Frequent Visitor
        9 years ago

        Hi Anonymous

         

        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