topic Re: ODBC Connection Issue to On Prem Oracle version 10c in Pipelines

ODBC Connection Issue to On Prem Oracle version 10c

MisterSmith — Tue, 04 Jun 2024 09:50:49 GMT

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.

Re: ODBC Connection Issue to On Prem Oracle version 10c

v-cboorla-msft — Tue, 04 Jun 2024 15:47:43 GMT

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.

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

Thank you.

Re: ODBC Connection Issue to On Prem Oracle version 10c

MisterSmith — Thu, 06 Jun 2024 10:45:42 GMT

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

Neil

Re: ODBC Connection Issue to On Prem Oracle version 10c

v-cboorla-msft — Mon, 10 Jun 2024 11:57:58 GMT

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 User Community

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

Thank you.

Re: ODBC Connection Issue to On Prem Oracle version 10c

MisterSmith — Mon, 10 Jun 2024 13:12:20 GMT

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

Thanks

Neil

Re: ODBC Connection Issue to On Prem Oracle version 10c

v-cboorla-msft — Mon, 10 Jun 2024 14:21:06 GMT

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.

Re: ODBC Connection Issue to On Prem Oracle version 10c

v-cboorla-msft — Tue, 11 Jun 2024 16:21:49 GMT

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.

Re: ODBC Connection Issue to On Prem Oracle version 10c

MisterSmith — Wed, 12 Jun 2024 07:16:27 GMT

Here is my reference number 2406110050000591

Neil

Re: ODBC Connection Issue to On Prem Oracle version 10c

MisterSmith — Thu, 13 Jun 2024 07:49:09 GMT

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.

Re: ODBC Connection Issue to On Prem Oracle version 10c

v-cboorla-msft — Thu, 13 Jun 2024 07:56:54 GMT

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.