Deploying a web server using Oracle.DataAccess results in various build errors

My development machine is Vista x64.

I use WCF web services to create web services that interact with the oracle 10g database.

When starting development, I was unable to use the built-in WCF testing tool [WCFTestClient] VS2008, which starts when I press F5 [Go] in the 32-bit version of Oracle.DataAccess.dll, because I get a System.BadImageFormatException on an Oracle Object. So in my development environment, I switched to the 64-bit version of ODP.NET for my referenced build, and that works fine.

I can deploy my local IIS [7], but only if I use 32-bit Oracle.DataAccess.dll.

I am trying to install on Win2003 [IIS 6] where .NET 3.5 sp1 is installed and the Oracle database 10g. Other web applications on this server successfully use oacle connections.

If I remove all references to Oracle.DataAccess from the web.config file and make sure that there is no Oracle.DataAccess.dll in my bin / folder, I can open the default service metadata page [s], but the service is called through the SOAP client leads to an error:

"Failed to load file or assembly" Oracle.DataAccess, Version = 10.2.0.100, Culture = neutral, PublicKeyToken = 89b483f429c47342 "or one of its dependencies. The system cannot find the specified file."

However, if I put a copy of the Oracle.DataAccess.dll file in the bin / folder, I get:

" " Oracle.DataAccess " . . ( HRESULT: 0x80131040)"

.svc -.

web.config, : " xxx"

, -, ODP.net, .

+3
3

, System.BadImageFormatException 32- Oracle.DataAccess , Any/x64. x86 IIS 7 32- ( → ... " 32- " "true" ), , , , , , 32 64- , , , , 32- 64- IIS 6.

+9

, [] , , .

32- ODP.NET 64- . VS Oracle.DataAccess.dll, odp.net/bin/2.x/.

SOAP .

: dll dll, ? 64- 32- , .

+2

, 32- DLL - .

, , Oracle 64bit dll 64-. DLL- "Any", 32- . , , , -, 32- dll , 32-.

64/32- dll , - , 32- dll/32bit . .

My honest suggestion would be, if possible, to evaluate alternative database solutions. My experience with Oracle was very painful.

Otherwise, just create a 32-bit version. This should not cause any problems.

+1
source

Source: https://habr.com/ru/post/1725322/


All Articles