Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Xaribdis
Regular Visitor

Error with ODBC connection to ODBC-JDBC bridge

Hi, 

I'm trying to connect PowerBI to Amazon Athena using a ODBC-JDBC bridge to keep DataZone authentication, which require a JDBC driver. The bridge I'm using is from OpenLink. 

I've configured the bridge and the test connection on the Data Origin Administrator is successful. However, when I try to connect to this data origin in PowerBI I get the following error:


Detalles: "ODBC: ERROR [IM003] No se puede cargar el controlador especificado debido al error del sistema 126: No se puede encontrar el módulo especificado. (OpenLink Lite for JDBC (9.0), C:\Program Files\OpenLink Software\UDA\bin\ntl9j18z.dll)."


The file specified in the path in the error exists, so I'm not sure what the problem is here.

Thanks

1 ACCEPTED SOLUTION

Hi @Xaribdis ,

 

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

View solution in original post

6 REPLIES 6
v-bmanikante
Community Support
Community Support

Hi @Xaribdis ,

 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

 

Regards,

B Manikanteswara Reddy

v-bmanikante
Community Support
Community Support

Hi @Xaribdis,

 

We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,
B Manikanteswara Reddy

v-bmanikante
Community Support
Community Support

Hi @Xaribdis,

 

we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,
B Manikanteswara Reddy

I've followed the suggested steps but it still not works with the same error. 

Also after researching further about the error the step of registering the DLL with regsvr32 seems to not be valid for every DLL, being this one of such cases. 
There is this post from 2018 with the same error and no solution provided, so I'm assuming this problem is not solved.

Hi @Xaribdis ,

 

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

v-vpabbu
Community Support
Community Support

Hi @Xaribdis,

 

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

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.