无法连接到 DB2:Azure 函数上的 IBM.Data.DB2.Core 版本 3.1.0.400 [英] Cannot connect to DB2: IBM.Data.DB2.Core version 3.1.0.400 on Azure Function

问题描述

我正在使用 nuget 包 IBM.Data.DB2.Core 版本 3.1.0.400 从带有 Azure Functions 版本 v3 (Windows) 的 Azure 函数连接到 IBM DB2 数据库.应用程序构建成功.

在本地执行它时，我面临以下异常.

IBM.Data.DB2.Core.DB2Exception (0x80004005): ERROR [] [IBM][CLI Driver] SQL10007N 消息0"无法检索.原因代码:6".在 IBM.Data.DB2.Core.ConnSettingsFromXmlConfig.ProcessFromXmlConfig(DB2Connection 连接、字符串 dbname、字符串主机、字符串端口、字符串 tmpClientEncAlg、字符串 tmpAuthentication、字符串 prevdb、字符串 prevdb_ori、DB2ConnSettings& sSettings、DB2ConnSettingsInternal& sSettingsInternal、StringBuilder& modifiedValue)在 IBM.Data.DB2.Core.DB2ConnPool.ReplaceConnectionStringParms(DB2Connection 连接，字符串 szValue，DB2ConnSettings 和 pSettings，DB2ConnSettingsInternal 和 pSettingsInternal，布尔 bAttach，布尔 pushDownStrAppended)在 IBM.Data.DB2.Core.DB2Connection.set_ConnectionString(字符串值)在 IBM.Data.DB2.Core.DB2Connection..ctor(字符串 connectionString)

这是代码片段，在实例化 DB2Connection 时，我遇到了异常.

使用 (var db2Connection = new DB2Connection(_configuration["DB2_ConnectionString"])){db2Connection.SystemNaming = true;

请注意.此代码在我能够连接到 DB2 的控制台应用程序中运行良好.

谢谢大家.

解决方案

Azure 函数支持目前在 Db2 .NET 中不可用提供者.它将在即将发布的 .NET 5 和.NET Core 3.1.

看https://community.ibm.com/community/user/hybriddatamanagement/communities/community-home/digestviewer/viewthread?GroupId=6163&MessageKey=2494b111-ffe7-4073-a8ec-e7e1c485e6d0&CommunityKey=f2e5dc34-896d-4e8e-9678-724907c4b9f5&tab=digestviewer&ReturnUrl=%2fcommunity%2fuser%2fhybriddatamanagement%2fcommunities%2fcommunity-home%2fdigestviewer%3fcommunitykey%3df2e5dc34-896d-4e8e-9678-724907c4b9f5%26>

I'm using nuget package IBM.Data.DB2.Core version 3.1.0.400 to connect to IBM DB2 database from Azure functions with Azure Functions Version v3 (Windows). Application builds successfully.

While executing it locally itself, I am facing following exception.

IBM.Data.DB2.Core.DB2Exception (0x80004005): ERROR [] [IBM][CLI Driver] SQL10007N Message "0" could not be retrieved.  Reason code: "6".

   at IBM.Data.DB2.Core.ConnSettingsFromXmlConfig.ProcessFromXmlConfig(DB2Connection connection, String dbname, String host, String port, String tmpClientEncAlg, String tmpAuthentication, String prevdb, String prevdb_ori, DB2ConnSettings& sSettings, DB2ConnSettingsInternal& sSettingsInternal, StringBuilder& modifiedValue)
   at IBM.Data.DB2.Core.DB2ConnPool.ReplaceConnectionStringParms(DB2Connection connection, String szValue, DB2ConnSettings& pSettings, DB2ConnSettingsInternal& pSettingsInternal, Boolean bAttach, Boolean pushDownStrAppended)
   at IBM.Data.DB2.Core.DB2Connection.set_ConnectionString(String value)
   at IBM.Data.DB2.Core.DB2Connection..ctor(String connectionString)

Here's the code snippet, where at the time of instantiating the DB2Connection I am getting above exception.

using (var db2Connection = new DB2Connection(_configuration["DB2_ConnectionString"]))
{
     db2Connection.SystemNaming = true;

Please note. This code works well as console application where I am able to connect to DB2.

Thank you all.

解决方案

the Azure functions support is currently not available in Db2 .NET provider. It will be available in the upcoming release of .NET 5 and .NET Core 3.1.

See https://community.ibm.com/community/user/hybriddatamanagement/communities/community-home/digestviewer/viewthread?GroupId=6163&MessageKey=2494b111-ffe7-4073-a8ec-e7e1c485e6d0&CommunityKey=f2e5dc34-896d-4e8e-9678-724907c4b9f5&tab=digestviewer&ReturnUrl=%2fcommunity%2fuser%2fhybriddatamanagement%2fcommunities%2fcommunity-home%2fdigestviewer%3fcommunitykey%3df2e5dc34-896d-4e8e-9678-724907c4b9f5%26tab%3ddigestviewer

这篇关于无法连接到 DB2:Azure 函数上的 IBM.Data.DB2.Core 版本 3.1.0.400的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！