Global Data Management Forum

 View Only
Expand all | Collapse all

Azure Function - SQL10007N Message "0" could not be retrieved. Reason code: "6"

  • 1.  Azure Function - SQL10007N Message "0" could not be retrieved. Reason code: "6"

    Posted Tue April 27, 2021 03:22 PM
    I'm trying to use IBM.Data.DB2.Core.DB2Connection (3.1.0.400) in an azure function, but it's throwing an exception in the constructor when setting the connection string. This works fine outside of azure, but I get this error when testing locally with the azure functions runtime and in azure.

    How can I get this working?

    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:

    var db2Connection = new DB2Connection(connectionString) {SystemNaming = true};

    ------------------------------
    John Rummell
    ------------------------------

    #DataManagementGlobal
    #DataServerDrivers


  • 2.  RE: Azure Function - SQL10007N Message "0" could not be retrieved. Reason code: "6"

    Posted Tue May 04, 2021 04:10 AM
    Hi John,
     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.

    Thanks
    Vishwa

    ------------------------------
    Hosathota Vishwanatha
    ------------------------------



  • 3.  RE: Azure Function - SQL10007N Message "0" could not be retrieved. Reason code: "6"

    Posted Tue May 04, 2021 09:19 AM
    Thanks, Hosathota!

    Do you have a timeline for the upcoming release? We're trying to move a number of scheduled tasks off of VMs and into Azure functions, and Db2 Connect is a big part of that plan. 


    ------------------------------
    John Rummell
    ------------------------------



  • 4.  RE: Azure Function - SQL10007N Message "0" could not be retrieved. Reason code: "6"

    Posted Wed May 05, 2021 12:52 AM
    Hi John,
     we keep updating the packages on a need basis and when there are some important updates. Current planned update is around November time but if there are critical fixes to be provided, we will release much before that. We will keep you updated on the availability of Azure functions.

    Thanks
    Vishwa

    ------------------------------
    Hosathota Vishwanatha
    ------------------------------



  • 5.  RE: Azure Function - SQL10007N Message "0" could not be retrieved. Reason code: "6"

    Posted Fri August 06, 2021 03:02 AM
    Edited by System Test Fri January 20, 2023 04:16 PM
    Hi John,
    we have made some progress in supporting Azure Functions and a new blog will be created soon to explain the steps. Are you still looking for the support? What combination you are planning? We are working on a combination of Azure Functions with HttpTrigger and with .NET Core packages. Please let us know what combination you were trying.

    Thanks
    Vishwa




  • 6.  RE: Azure Function - SQL10007N Message "0" could not be retrieved. Reason code: "6"

    Posted Thu August 19, 2021 02:19 PM
    Hi Vishwa

    We're interested in .NET Core timer trigger functions at the moment.

    Thanks!


    ------------------------------
    John Rummell
    ------------------------------