Forum Discussion

MisterSmith's avatar
MisterSmith
Icon for Helper I rankHelper I
2 years ago
Solved

ODBC Connection Issue to On Prem Oracle version 10c

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 wh...
Need Help
pipelines
  • MisterSmith's avatar
    MisterSmith
    2 years ago

    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's avatar
v-cboorla-msft
Icon for Microsoft Employee rankMicrosoft Employee
2 years ago

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.