Skip to Content (Press Enter)
2015-04-07 21-32-04
Julius King Chua
8Views
2Comments
Oracle External DB - Attempt to load Oracle client libraries
Question
Oracle
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.

Thanks!
1
0
12 Sep 2013
Copy Link
2015-04-07 21-32-04
Julius King Chua
To share my solution, I have tweaked IIS's Application Pool to "Enable 32-bit Applications" checked! :)
0
0
14 Sep 2013
Copy Link
2014-02-13 10-06-38
Ricardo Silva
You could also install the 64 bit Oracle client tools :)
1
0
14 Sep 2013
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.