[BadImageFormatException: 试图加载格式不正确的程序。 (Exception from HRESULT: 0x8007000B)]
System.Data.Common.UnsafeNativeMethods.OCILobCopy2(IntPtr svchp, IntPtr errhp, IntPtr dst_locp, IntPtr src_locp, UInt64 amount, UInt64 dst_offset, UInt64 src_offset) +0
System.Data.OracleClient.OCI.DetermineClientVersion() +126
[InvalidOperationException: 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.]
System.Data.OracleClient.OCI.DetermineClientVersion() +586
System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName) +37
System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions) +129
System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) +40
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +31
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +548
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +69
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +470
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +108
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +118
System.Data.OracleClient.OracleConnection.Open() +43
DbOra.Query(String SQLString, String conn) in d:\yasm\yasmSite\App_Code\DbOra.cs:298
command.getarea_camera() in d:\yasm\yasmSite\ajaxservice\command.ashx:92
command.ProcessRequest(HttpContext context) in d:\yasm\yasmSite\ajaxservice\command.ashx:71
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +341
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +69
如果需要安装客户端后还报以上错误的话,
环境:
1.在window 2008 64 bits + IIS7.5的服务器上部署一个项目
2.build了一个release + any CPU模式下的package
问题:
当部署完成后,run该项目的流程发现出现如下问题:
System.InvalidOperationException: 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.
分析:
提示很明显在64 bits的环境下使用了32位的oracle客户端组件。但是我们检查oracle是安装的64bits的服务端程序,并没有安装32的任何组件。
检查IIS配置,发现Application Pool被设置成了运行32位模式。那么这样会导致程序使用32位的Oracle客户端运行在这32位的应用程序池。
因为IIS启动该应用程序池的工作进程,是一个32位的过程中,当它试图加载CLR,它会加载的32位CLR,因此将在32位模式下加载程序集。这即使您的程序集编译为64位和32位模式。在32位模式下运行您的程序集,然后可以调用Oracle客户端,将在32位模式下运行。
解决:
我通过设置application pool的配置Application Pools -> Advanced Settings -> Enable 32-Bit Applications为false,此问题就解决了