Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

ODBC: ERROR [08004] [ODBC Firebird Driver]File Database is not found

Good afternoon guys,

 

I have a Firebird database that I am trying to work on using Power BI. Unforunately once I manage to connect to the database using ODBC I get the following error:

I can assure you that the database is not being used but anyone and anything but Power BI. When I cancel the connection and try to connect to it again I get the same error (sorry for it not being in English language) but while making the connection.

Once I close Power BI and then open it again I am able to connect to the database but I get the error. I do not know whether that means anything but the database file is located on my PC hardrive. 

 

I would be thankful for any kind of advice or help regarding this issue.

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      I have to add something. I am not the only one experiencing this issue and my suspicion is there is something wrong with the database file itself because other Firebird database files work just fine. They are way smaller in size but still they do actually work and we do not have the same issues with them.

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Icon for Community Support rankCommunity Support

    Hi Anonymous ,

     

    It is possible that the Firebird client you installed is 32 bit, resulting in a mismatch. Please try to install 64 bit.

    For more details, please check this link.

     

    firebird2.5 - ODBC Firebird Driver Unable to connect to data source;library'gds32.dll' failed to load - Stack Overflow

     

    Best Regards

    Community Support Team _ chenwu zhu

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable

      I am not sure what the problem was but I put the same database file on the server and I had no issues with connecting to it or managing it. There has to be some kind of issue when I want to use it while the file is on a PC's hard drive.

       

      Anyway the topic may be considered closed.