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

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

  • YelloBlack's avatar
    YelloBlack
    Frequent Visitor
    9 years ago

    Hi Anonymous

     

    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's avatar
      YelloBlack
      Frequent Visitor
      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

      • edejes2's avatar
        edejes2
        Advocate IV
        9 years ago

        Hello, 

         

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

         

        Regards!

        Erich Dejesus