Oracle External DB - Attempt to load Oracle client libraries

Oracle External DB - Attempt to load Oracle client libraries

Good day everyone.

I have a problem adding the connection string in Service Center with an external Oracle database. I am aiming at adding existing tables from the Oracle database to the application using Integration Studio.

First error is that I do not have permissions to access Oracle folder, which is I have resolved. The next error that came up is this exception:

"Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64-bit mode with the 32-bit Oracle client components installed."

I have Windows Server 2008 R2 64-bit installed in the virtual machine with Oracle 10g as the external DB from a server, while the Oracle client is 32-bit. I am a bit sure that the Oracle client is the one causing the problem.

Any advice on how to resolve the following exception and continue to test the connectivity successfully.

To share my solution, I have tweaked IIS's Application Pool to "Enable 32-bit Applications" checked! :)
You could also install the 64 bit Oracle client tools :)