DB2 .Net连接器错误:AESEncryptADONet [英] DB2 .Net Connector error : AESEncryptADONet

问题描述

我有一个非常简单的.Net Core应用程序，试图创建并打开与DB2数据库的连接(在AS/400上).当我尝试创建带有消息的DBConnection对象时出现此错误:

I have a very simple .Net Core app trying to create and open a connection to a DB2 database (on AS/400). I have this error when I try to create the DBConnection object, with the message:

错误58005 SQL0902没有上下文策略.功能:AESEncryptADONet .

不幸的是，没有更多细节了.

There are no more details, unfortunately.

推荐答案

我们遇到了相同的错误，并通过在Windows/Linux上设置环境变量的 Path 解决了该错误( LD_LIBRARY_PATH )/MacOS( DYLD_LIBRARY_PATH ).例如:

We meet the same error and solved it by setting Path of environment variables on Windows / Linux (LD_LIBRARY_PATH) / MacOS (DYLD_LIBRARY_PATH). For example:

1. 我们的环境:
   • ASP.NET Core v3.1
   • v11.5.4中的IBM .NET Core 3.1/EntityFrameworkCore 3.1
   • IIS 8.5
   • Windows Server 2012 R2(64位)

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <location ... >
    <system.webServer>

      ...

      <aspNetCore ... >
        <environmentVariables>
          <environmentVariable name="Path" value="C:\Users\Administrator\.nuget\packages\ibm.data.db2.core\3.1.0.200\buildTransitive\clidriver\bin" />
        </environmentVariables>
      </aspNetCore>
    </system.webServer>
  </location>
</configuration>

设置应用程序池标识帐户( IIS AppPool \ [App_Pool_Name] )的文件夹权限(读取和执行，读取和列出文件夹内容)

Set folder permissions (Read & Execute, Read, and List Folder Contents) for Application Pool Identity Accounts (IIS AppPool\[App_Pool_Name])

请单击下面的链接以获取更多信息.

Please click the links below for more information.

• 问:我遇到以下错误:

  Q: I am getting the following error:

  进程:244功能:AESEncryptADONET(加密信息)中发生了意外的异常

  An unexpected exception has occurred in Process: 244 Function: AESEncryptADONET (Encryption Info)

  .NET驱动程序无法找到兼容的GSKit.将 Path (在Windows上)或 LD_LIBRARY_PATH (在Linux上)设置为< Package_Install_location>/< package-name>/< version>/build您的环境的/clidriver/lib 目录.请记住，这可能会影响其他应用程序.

  The .NET driver is unable to find the compatible GSKit. Set the Path(on Windows) or LD_LIBRARY_PATH(on Linux) to the <Package_Install_location>/<package-name>/<version>/build/clidriver/lib directory of your environment. Remember, this may affect other applications.

• Db2 .NET软件包的下载和初始配置

这篇关于DB2 .Net连接器错误:AESEncryptADONet的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！