我收到了上述提到的错误信息。我已经进行了足够的研究并尝试了各种选项，但仍然没有运气。
以下是详细信息：
OS: Windows 7 64 bit version
Visual studio version: 2013 Premium
.NET framework version is : 4.0.30319
ASP.NET version: 4.0.30319.34249
IIS version: 7.0
DB2 installed path: C:\Program Files (x86)\IBM
DLL path: C:\Program Files (x86)\IBM\SQLLIB\BIN\netf40\IBM.DB2.dll
DLL Version: 9.7.4.4
我要介入并分享我的步骤，以完全自动化部署IBM的.Net数据提供程序，因为这是我尝试让它正常工作时遇到的第一个错误，也是众多错误中的第一个。我希望通过阅读这些步骤，有人可以避免被困在痛苦之轮上。
Next, you will need to set the DLLs that you just referenced not be included in the BIN folder by setting the DLLs to Copy Local FALSE by Right Clicking the references and going to properties.
If these are put in the BIN you will get the error message:
[BadImageFormatException: Could not load file or assembly 'IBM.Data.DB2' or one of its dependencies. An attempt was made to load a program with an incorrect format.]
IBM's reference to the issue: http://www-01.ibm.com/support/docview.wss?uid=swg21902663
Exception Message: Could not load file or assembly 'IBM.Data.DB2, Version=9.7.4.4, Culture=neutral, PublicKeyToken=7c307b91aa13d208' or one of its dependencies. The system cannot find the file specified.
Now you need to deploy and you realize you have a problem with automating installing a DB2 driver and start looking for solutions:
Not wanting to manually install on DEV/QA/STG/PROD, I found the that you can install IBM Data Server Client Package silently via command line using a response file. About halfway down this page: https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.swg.im.dbclient.install.doc/doc/t0007315.html you will find the relevant information after this line:
To install the IBM Data Server Driver Package software, run the v10.5fpX_ntxYY_dsdriver_EN command. The X represents the fix pack number value and the YY represents either 32-bit or 64-bit release.
A link to a sample response file to copy and change with your information is here: https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.apdv.sample.doc/doc/dsdriver/s-dsdriver-rsp.html
Now you are all set right? WRONG. Apparently a "successful install" doesn't include moving the appropriate DLLs to the GAC and registering them in the Registry. Thanks IBM: https://www-01.ibm.com/support/docview.wss?uid=swg21618434
Not wanting to give up in my automated deploy dreams, I put all the above knowledge into a Powershell script:
param([string]$driverPath,[string]$installPath)
[System.Reflection.Assembly]::Load("System.EnterpriseServices, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")
$publish = New-Object System.EnterpriseServices.Internal.Publish
Write-output "Installing v11.1.2fp2a_ntx64_dsdriver_EN.exe"
& "$driverPath\v11.1.2fp2a_ntx64_dsdriver_EN.exe" /u "$driverPath\DB2.cfg" /l "$driverPath\log.txt" | Out-null
$publish.GacInstall("$installPath\bin\netf20\IBM.Data.DB2.dll") | Out-null
$publish.GacInstall("$installPath\bin\netf20_32\IBM.Data.DB2.dll") | Out-null
$publish.GacInstall("$installPath\bin\netf40\IBM.Data.DB2.dll") | Out-null
$publish.GacInstall("$installPath\bin\netf40_32\IBM.Data.DB2.dll") | Out-null
$publish.GacInstall("$installPath\bin\netf20\IBM.Data.DB2.Entity.dll") | Out-null
$publish.GacInstall("$installPath\bin\netf20_32\IBM.Data.DB2.Entity.dll") | Out-null
$publish.GacInstall("$installPath\bin\netf40\IBM.Data.DB2.Entity.dll") | Out-null
$publish.GacInstall("$installPath\bin\netf40_32\IBM.Data.DB2.Entity.dll") | Out-null
Now you will find that you are getting another error. Until now you were only fighting IBM.Data.DB2.*.dll issues. The following error is now present:
Exception Message: Unable to load DLL 'db2app64.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)
Come on IBM!! A quick Google search finds the same results we got with the #1. "Change your app to 32-bit" This is wrong, of course, we know better now!
I'll help you out and let you know that this DLL was installed along with the OTHER DLLs, just in a different path!
Just add them to the bottom of the Powershell script:
$publish.GacInstall("$installPath\bin\db2app.dll") | Out-null
$publish.GacInstall("$installPath\bin\db2app64.dll") | Out-null
DISM /Image:C:\test\offline /Enable-Feature /FeatureName:NetFx3 /All /LimitAccess /Source:D:\sources\sxs
<dsncollection>
<dsn alias="DBDSNSAMPLE" name="DBDSNSAMPLE" host="127.0.0.1" port="50001"/>
</dsncollection>
<databases>
<database name="DBDSNSAMPLE" host="127.0.0.1" port="50001">
</database>
</databases>
</configuration>
添加连接后，您可以使用testconn40.exe测试连接。打开cmd并定位到C:\Program Files\IBM\IBM DATA SERVER DRIVER\bin并执行：
> testconn40 DBDSNSAMPLE
此命令不会登录您（因为我们在.cfg文件中没有指定用户凭据），但至少它将显示正确的消息，这意味着您的.NET应用程序将正常工作。否则，它将显示一些异常错误。
using (var conn = new DB2Connection($"Database={u.db2a};UserID={u.db2u};Password={u.db2p};Server={u.db2i}"))
using (var cmd = new DB2Command())
{
cmd.CommandText = "SELECT * FROM Table1";
cmd.Connection = conn;
conn.Open();
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
Console.WriteLine(reader.GetValue(3));
}
}
}
gacutil /i "C:\Program Files\IBM\IBM DATA SERVER DRIVER\bin\netf20\IBM.Data.DB2.dll"
gacutil /i "C:\Program Files\IBM\IBM DATA SERVER DRIVER\bin\netf20_32\IBM.Data.DB2.dll"
gacutil /i "C:\Program Files\IBM\IBM DATA SERVER DRIVER\bin\netf40\IBM.Data.DB2.dll"
gacutil /i "C:\Program Files\IBM\IBM DATA SERVER DRIVER\bin\netf40_32\IBM.Data.DB2.dll"
gacutil /i "C:\Program Files\IBM\IBM DATA SERVER DRIVER\bin\netf20\IBM.Data.Informix.dll"
gacutil /i "C:\Program Files\IBM\IBM DATA SERVER DRIVER\bin\netf20_32\IBM.Data.Informix.dll"
gacutil /i "C:\Program Files\IBM\IBM DATA SERVER DRIVER\bin\netf40\IBM.Data.Informix.dll"
gacutil /i "C:\Program Files\IBM\IBM DATA SERVER DRIVER\bin\netf40_32\IBM.Data.Informix.dll"
gacutil /i "C:\Program Files\IBM\IBM DATA SERVER DRIVER\bin\netf20\IBM.Data.DB2.Entity.dll"
gacutil /i "C:\Program Files\IBM\IBM DATA SERVER DRIVER\bin\netf20_32\IBM.Data.DB2.Entity.dll"
gacutil /i "C:\Program Files\IBM\IBM DATA SERVER DRIVER\bin\netf40\IBM.Data.DB2.Entity.dll"
gacutil /i "C:\Program Files\IBM\IBM DATA SERVER DRIVER\bin\netf40_32\IBM.Data.DB2.Entity.dll"
gacutil /i "C:\Program Files\IBM\IBM DATA SERVER DRIVER\bin\db2app.dll"
gacutil /i "C:\Program Files\IBM\IBM DATA SERVER DRIVER\bin\db2app64.dll"
你可以在命令提示符中尝试以下操作：
regsvr32 "C:\Program Files\IBM\IBM DATA SERVER DRIVER\bin\db2app64.dll"
regsvr32 "C:\Program Files\IBM\IBM DATA SERVER DRIVER\bin\db2app.dll"
看起来你正在尝试从一个在64位模式下运行的.NET应用程序中加载一个32位编译的IBM DB2驱动程序。尝试将配置管理器更改为以x86模式运行。
我最近遇到了这个问题。我发现在Visual Studio的发布过程中，会将IBM.Data.DB2.dll的一个副本放在Web应用程序的BIN目录中。当手动删除它时，Web应用程序开始正常运行。我不知道为什么它会被发布，因为它没有直接引用。
我发现解决这个问题最简单的方法是使用后期构建事件。
项目属性-->生成事件-->后期构建事件命令行
这是我正在使用的命令行：
del $(TargetDir)\IBM.Data.DB2.dll
- 如果没有nuget包，请安装客户端SDK，并确保正确选择环境（32/64位）。
- 将项目包含在vs中时，请将“复制本地”设置为false。
- 服务器安装（使用正确的环境32/64位主机应用程序）-不包括informix驱动程序，只有db2。运行informix的客户端sdk安装程序。
- 出现异常缺少其他dll文件。更新路径变量以指向install/bin目录。重新启动服务器使路径生效。无需手动在GAC中注册其他dll文件。
- Jim