FailedNo error information available: E_NOINTERFACE(0x80004002).

最新推荐文章于 2019-10-02 08:53:38 发布

原创最新推荐文章于 2019-10-02 08:53:38 发布 · 2.1k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#exception #function #cmd #access #string #微软

博客指出使用COM+自动事务时，用Access调用DTC会出现莫名其妙的错误代码，如E_NOINTERFACE(0x80004002)，微软有相关kb文档。还给出了示例代码，包含HelloWorld函数及DrawMoneyFromA、DepostMoneyToB子过程，处理事务异常。

用COM+ 的自动事务，必须操作的对象支持，用access 调用dtc，会有莫名其妙的错误代码

FailedNo error information available: E_NOINTERFACE(0x80004002).

关于这个问题，微软有一片kb

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q221071&

<WebMethod(transactionOption:=EnterpriseServices.TransactionOption.RequiresNew)> _
    Public Function HelloWorld() As String
        Try
            ContextUtil.EnableCommit()

            DrawMoneyFromA(1000)
            DepostMoneyToB(1000)
            ContextUtil.SetComplete()
            Return "OK!"
        Catch ex As Exception
            ContextUtil.SetAbort()
            Return "Failed" + ex.Message
        End Try

End Function

    Public Sub DrawMoneyFromA(ByVal amount As Long)
        '从 A 中提取一定的钱
        Dim cnn As New OleDb.OleDbConnection(Me.OleDbConnection1.ConnectionString)
        cnn.Open()
        Dim cmd As New OleDb.OleDbCommand("Update bank set amount=amount - " & amount & " where bankaccount='A'", cnn)
        cmd.ExecuteNonQuery()

End Sub

    Public Sub DepostMoneyToB(ByVal amount As Long)
        '从 B 加一定的钱
        Dim cnn As New OleDb.OleDbConnection(Me.OleDbConnection1.ConnectionString)
        cnn.Open()
        Dim cmd As New OleDb.OleDbCommand("Update bank set amount=amount + " & amount & " where bankaccount='B'", cnn)
        'Throw New Exception("ff")
        cmd.ExecuteNonQuery()

End Sub