Forum Discussion
Error with ODBC connection to ODBC-JDBC bridge
Hi Anonymous ,
Apologies for the delay in getting back to you
It looks like the issue you're facing is very similar to one that another user encountered earlier. That issue has been resolved, and the solution might be helpful in your case as well.
Please refer to the post linked below for the full explanation and steps:
Solved: Can't import large dataset in desktop and service ... - Microsoft Fabric Community
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
B Manikanteswara Reddy
Hi Anonymous,
Thank you for reaching out to Microsoft Fabric Community Forum.
If you're encountering System Error 126 when connecting Power BI to Amazon Athena via an ODBC-JDBC bridge, it’s likely due to a missing or unregistered DLL. Here are some steps to resolve it:
1.Ensure you are using the correct 64-bit or 32-bit driver matching your Power BI version
2.you need to register the DLL, you can Open Command Prompt as Administrator and run:
regsvr32 "C:\Program Files\OpenLink Software\UDA\bin\ntl9j18z.dll"2.
3.Check for the missed dependencies, for this you can use Dependency walker to verify missing DLL. Install necessary Microsoft Visual C++ Redistributables from Microsoft’s site.
4.Add the driver path to System Environment Variables under Path:
C:\Program Files\OpenLink Software\UDA\bin\
5.then Run Power BI as Admin by Right-click on Power BI Desktop → Run as Administrator.
6 If the issue repeats, please uninstall the OpenLink driver, restart your PC, reinstall the latest version, and reconfigure the ODBC-JDBC bridge.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
Vinay Pabbu