Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Using the enterprise gateway I am getting an error when using ODBC with DRIVER={InterSystems ODBC}. Has anyone had this issue before and resolved it?
ODBC: ERROR [08S01] [Cache ODBC][State : 08S01][Native Code 461] [C:\Program Files\On-premises data gateway\Microsoft.Mashup.Container.NetFX40.ex] Communication link failure ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).
Solved! Go to Solution.
Hi Qiuyun Yu,
It turns out that I needed to upgrade to the latest ODBC driver for my database. Now it is working.
Thanks,
twinrabbits
Hi, could help me.
I have a similar problem. I use "Intersystem ODBC Driver" version 1.00.0000 , what's version do you use?
Thanks
I am using version 2016.02.01.803
I try use ODBC with base Caché - intersystem
Hi @twinrabbits,
Have you tried to connect to this ODBC data source in Power BI Desktop? What's the version of ODBC did you create, 32 bit or 64 bit? Please try to check the on-premises data gateway service logs ( C:\Users\PBIEgwService\AppData\Local\Microsoft\on-premises data gateway\Gateway*.log ) around the time error throws out, share it with us if possible.
Best Regards,
Qiuyun Yu
Hi Qiuyun Yu,
It turns out that I needed to upgrade to the latest ODBC driver for my database. Now it is working.
Thanks,
twinrabbits
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |