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

[Tomasi]

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.

[v-chenwuz-msft]

Hi @Tomasi ,

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 loa...

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.

[Tomasi]

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.

[negi007]

@Tomasi this seems to be a dsn error. You might have created your odbc dsn in such a way that it is throwing error in powerbi. 

try below link for help

Solved: Unable to connect to Firebird DB with ODBC (DMTS_P... - Microsoft Power BI Community

[Tomasi]

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.