I want to create a sharepoint 2010 webservice with 3.5 framework which allows to connect with oracle and perform the basic database operations. i had used 2 methods to connect with oracle both went in vain. first i used oracle.dataaccess dll to connect with oracle. but it threw badimageformat exception due to the framework of the dependency dlls. After that system.data.oracleclient, since sharepoint apppool is 64 bit it threw an exception as"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." Is there any way to connect oracle with sharepoint webservice??? Please help!!!!!

Hi,

Per my knowledge, if you want to connect with Oracle using Oracle client libraries in 64 bit operation system, we need to install the 32 bit Oracle client library.

In addition, we need to check "Enable 32-bit Applications" in IIS application pool advanced settings like the capture below:

Here is a similiar thread for your reference:

http://stackoverflow.com/questions/16538561/run-oracle-client-in-32-bit-mode-on-a-64-bit-machine

Thanks

Best Regards

Since I have to create a sharepoint webservice, is it possible to set "Enable 32-bit Applications" to true???

Hi,

Per my knowledge, if you want to connect with Oracle using Oracle client libraries in 64 bit operation system, we need to install the 32 bit Oracle client library.

Here is a similiar thread for your reference:

http://stackoverflow.com/questions/16538561/run-oracle-client-in-32-bit-mode-on-a-64-bit-machine

Thanks

Best R

Hi,

No, in SharePoint 2010 IIS web application pool, we can't "Enable 32-bit Applications", if enabled it, then will cause Https 503 error.

If SharePoint 2010 hosted application needs 32 bit Applications mode, it is recommended to move it to their own web application.

Here is  a detailed article for your reference:

SharePoint 2010: IIS application pool settings can cause site not to load

Thanks

Best Regards