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

问题描述

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

<块引用>

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

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

解决方案

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

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 位)
2. 在 web.config 中，我们添加 .

   <配置><位置... ><system.webServer>...<aspNetCore ... ><环境变量><环境变量名称=路径"值=C:UsersAdministrator.nugetpackagesibm.data.db2.core3.1.0.200uildTransitiveclidriverin"；/></环境变量></aspNetCore></system.webServer></位置></配置>

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

请点击以下链接了解更多信息.

• 有关 IBM Db2 .NET Core Provider 的常见问题<块引用>

  问:我收到以下错误:

  <块引用>

  进程中发生意外异常:244 函数:AESEncryptADONET(加密信息)

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

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

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:

ERROR 58005 SQL0902 There are no context policies. Function: AESEncryptADONet.

There are no more details, unfortunately.

解决方案

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. Our environment:
   • ASP.NET Core v3.1
   • IBM .NET Core 3.1 / EntityFrameworkCore 3.1 in v11.5.4
   • IIS 8.5
   • Windows Server 2012 R2 (64 bits)
2. In web.config, we add the <environmentVariable name="Path" value="C:UsersAdministrator.nugetpackagesibm.data.db2.core3.1.0.200uildTransitiveclidriverin" />.

   <?xml version="1.0" encoding="utf-8"?>
   <configuration>
     <location ... >
       <system.webServer>
   
         ...
   
         <aspNetCore ... >
           <environmentVariables>
             <environmentVariable name="Path" value="C:UsersAdministrator.nugetpackagesibm.data.db2.core3.1.0.200uildTransitiveclidriverin" />
           </environmentVariables>
         </aspNetCore>
       </system.webServer>
     </location>
   </configuration>
   

3. 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.

• Frequently asked questions about IBM Db2 .NET Core Provider

  Q: I am getting the following error:

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

  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 Packages downloading and initial configuration

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