ODBC Connection Issue to On Prem Oracle version 10c

[MisterSmith]

All

I have an issue setting up a connection to an older version of Oracle.  I have set up an ODBC connection on the On Prem server that hosts the gateway, and I've tested the connection.  However when I try to create a ODBC connection in Fabric, I get the following error.

An exception occurred: ODBC: ERROR [IM003] Specified driver could not be loaded due to system error 1114: A dynamic link library (DLL) initialization routine failed. (Oracle in OraClient19Home2, C:\Program Files\Oraclev19\product\19.0.0\client_2\BIN\SQORA32.DLL).

I'm using the ODBC connection instead of the Oracle on as it is version 10c.  I have installed the oracle client as well as the Oracle Client for Microsoft tools.

Any advice would be appreciated.

[MisterSmith · Accepted solution]

This is now resolved.  I tried a number of things, before testing.  But best guess that it was the permissions for the Power BI service for the on prem gateway.  I gave it read and write permissions to the oracle folder in Program files.

[v-cboorla-msft]

Hi @MisterSmith 

Glad that your query got resolved and thank you for sharing the same with the community as it can be helpful to others.
Please continue using Fabric Community for further queries.

Thank you.

[MisterSmith]

Thank you for getting back to me.  I can confirm that I have installed the 64-bit client on our server.  

Neil

[v-cboorla-msft]

Hi @MisterSmith 

Please refer the following links which might help you.

Link 1 : system error 1114: A dynamic link library (DLL) initialization routine failed - Oracle Forums

Link 2 : Solved: Oracle ODBC Error 1114: A dynamic link library (DLL) initialization routine fail... - JMP Us...

If the issue still persists, please do let us know. Glad to help.

Thank you.

[MisterSmith]

Hi I've reviewed and updated the system variables but it has not fixed the issue.

Thanks

Neil

[v-cboorla-msft]

Hi @MisterSmith 

Apologies for the inconvenience.

Please reach out to our support team to gain deeper insights and explore potential solutions. It's highly recommended that you reach out to our support team. Their expertise will be invaluable in suggesting the most appropriate approach.

Please go ahead and raise a support ticket to reach our support team:

https://support.fabric.microsoft.com/support

After creating a Support ticket please provide the ticket number as it would help us to track for more information.

Thank you.

[v-cboorla-msft]

Hi @MisterSmith 

We haven’t heard from you on the last response and was just checking back to see if you've had a chance to submit a support ticket. If you have, a reference to the ticket number would be greatly appreciated. This will allow us to track the progress of your request and ensure you receive the most efficient support possible.

Thank you.

[MisterSmith]

Hi

Here is my reference number 2406110050000591

Neil

[v-cboorla-msft]

Hi @MisterSmith 

Thanks for using Microsoft Fabric Community.

The error message "ODBC: ERROR [IM003] Specified driver could not be loaded due to system error 1114" indicates an issue with the Oracle ODBC driver while connecting to an older Oracle version in Microsoft Fabric.

The error message mentions "SQORA32.DLL" which is a 32-bit DLL. You might be using a 64-bit application (Microsoft Fabric) with a 32-bit Oracle Client.

Verify if a 64-bit Oracle Client is installed. If not, download and install the compatible 64-bit version for your Oracle database version from the Oracle website.

For similar issue please refer : Solved: ODBC: ERROR [IM003] Specified driver could not be ... - Microsoft Fabric Community

If the issue still persists, please do let us know. Glad to help.

Thank you.