ODBC connection and power bi

[Ameen Odah]

Hi,

I want to connect my firebird database by power bi , and where the power bi used odbc 64 bit 

i install the client dll 64 bit 

but when i click on test connection the odbc setup crashed and closed 

what you suggest ?! 

[Dimitry Sibiryakov]

Ameen Odah wrote 04.02.2024 9:26:
> but when i click on test connection the odbc setup crashed and closed
> what you suggest ?!

Try this release: https://github.com/aafemt/firebird-odbc-driver/releases
It was specifically tested with Power BI.

--
WBR, SD.

[hamacker]

Some times ODBC (v3 beta) run satisfactory and others times, not. 

I create this issue to help them to discovery what´s happening:

https://github.com/FirebirdSQL/firebird-odbc-driver/issues/216

If you have the same problem, please wait.

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/513b8a6b-79d8-4418-a9d5-24943378e57c%40ibphoenix.com.

[Dimitry Sibiryakov]

hamacker wrote 06.02.2024 15:12:
> If you have the same problem, please wait.

I don't have problem. I asked you to check if my fork of the ODBC driver has
the same problem.
But you are free to wait while they fix main branch of course.

--
WBR, SD.

[hamacker]

To test all scenarios, I discover that powerBI read metadata a lot. 

When I choose table "A", if there is FK to link table "B". PowerBI read metadata from "B" too. I think that powerBI create a spider web when you touch any table. My database is not big, but has several FK, Constraints, Indexes and all fields are domains. When I create a new database to test ODBC driver, convert all domains to raw values, remove constraints and FKs...does not show error anymore!

So, I think the problem is metadata reading.

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/e46f36ba-c890-4986-992e-f4db6ab2a8d5%40ibphoenix.com.

[Dimitry Sibiryakov]

hamacker wrote 07.02.2024 14:30:
> When I choose table "A", if there is FK to link table "B". PowerBI read metadata
> from "B" too. I think that powerBI create a spider web when you touch any table.

Yes, and every single query is executed in a separate attachment. It is the
most stupid way to work with database ever.

--
WBR, SD.

[hamacker]

latests news!

Lastest update of driver ODBC for Firebird3+ in:

https://github.com/FirebirdSQL/firebird-odbc-driver/wiki

Does not have more problems with PowerBI in Firebird 4.0.4 and Firebird 5, now running fine:

https://github.com/FirebirdSQL/firebird-odbc-driver/issues/216

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/37e86bc1-8267-43fa-a041-5ee7ad347bc4%40ibphoenix.com.