IBM Data Server Drivers (Db2 Connect Client)

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 8 days ago
    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
    ------------------------------


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

    Posted 2 days ago
    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 2 days ago
    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 yesterday
    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
    ------------------------------