Reply
coatsy35
Helper I
Helper I

ODBC Error Help

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

coatsy35_0-1727388102410.png

or in PowerBi

coatsy35_1-1727388166493.png

 

Any ideas greatfully received.

 

1 ACCEPTED SOLUTION
v-junyant-msft
Community Support
Community Support

Hi @coatsy35 ,

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

vjunyantmsft_0-1727398876218.png

vjunyantmsft_1-1727399083730.png

Please try upgrading your ODBC to version 3.0 before reconnecting:

vjunyantmsft_2-1727399109720.png

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.

View solution in original post

2 REPLIES 2
v-junyant-msft
Community Support
Community Support

Hi @coatsy35 ,

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

vjunyantmsft_0-1727398876218.png

vjunyantmsft_1-1727399083730.png

Please try upgrading your ODBC to version 3.0 before reconnecting:

vjunyantmsft_2-1727399109720.png

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.

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

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)