ODBC Error Help

[coatsy35]

We have a system at work whihc uses a synergex xfODBC driver. To connect to it via Excel you need to use legacy microsoft query which works perfectly and I can view and manipulate all tables. If I want to connect to it using power query or PowerBI I get the following error. Can anyone shed any light on it?

In Excel

or in PowerBi

Any ideas greatfully received.

[Anonymous · Accepted solution]

Hi @coatsy35 ,

From the screenshot of your error report, it seems to be caused by your ODBC version being too low:

Please try upgrading your ODBC to version 3.0 before reconnecting:

SQLSetEnvAttr Function - ODBC API Reference | Microsoft Learn


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

[coatsy35]

All sorted. Contacted the supplier of the software and they had updated drivers and all working now.