Forum Discussion

josmond's avatar
josmond
Regular Visitor
2 years ago
Solved

Gateway not seeing ODBC Data Source

I have a Power BI Gateway cluster. PBIGateway (Primary) Server A - local ODBC_Source_A PBIGateway2  (new)    Server B - local ODBC_Source_A (configured same as above)   In Gateway connections ODB...
Need Help
  • josmond's avatar
    josmond
    2 years ago

    collinq  I figured it out !  It was specific to the Unidata ODBC driver I am using.

    I needed to edit the ODBC configuration file "As Admin" or the permssions would get messed up.

    All is working now. Thanks for your replies.

collinq's avatar
collinq
Super User
2 years ago

Hi josmond ,

 

Do you have the ODBC set up on BOTH the gateway servers?  Particularly the one on A?  (And, are they exactly the same - same name, same version of ODBC drivers, same bit count (64-bit), etc.)?  And, confirm that it tests successfully?

 

 

 

 

josmond's avatar
josmond
Regular Visitor
2 years ago

Yes, both gateway servers have the same ODBC setup, same driver, both System DSN's, both tested, and both with the same name

  • collinq's avatar
    collinq
    Super User
    2 years ago

    Hey josmond ,

     

    I think that you probably should open a Microsoft ticket on this one.  I don't know of any other steps to confirm that this should be working (not saying there aren't, just saying that I don't think there are any).

    • josmond's avatar
      josmond
      Regular Visitor
      2 years ago

      collinq  I figured it out !  It was specific to the Unidata ODBC driver I am using.

      I needed to edit the ODBC configuration file "As Admin" or the permssions would get messed up.

      All is working now. Thanks for your replies.