none
RunTime Error -2147467259 (800004005) - Assistance Required RRS feed

  • Question

  • I'm getting an error with this script:

                   SprocName = "exec [ocs].[InsertSCInfoForMissingConsent]"

                   Para = OCSid & ", " & ACid & ", '" & ACvert & "', '" & DofCall & "', '" & Tel & "', " & TofCallID & ", '" & InOutBound & "'"

                   FinalCommandText = SprocName & " " & Para

               

                   Set CMD1 = New ADODB.Command

                   CMD1.ActiveConnection = cnnConnect

                   CMD1.CommandText = FinalCommandText

                   CMD1.CommandType = adCmdText

               

                   Set rs = CMD1.Execute()

                   Set rs = Nothing

                  

    IsAnswer = MsgBox("Complete", vbOKOnly, "Confirmation")

    What am I doing wrong?

    Thursday, October 11, 2018 7:50 PM

All replies

  • Hello,

    Although this is generally VB.NET someone here might have an idea but only if you indicate the exact error (which means provide in text the error message).


    Please remember to mark the replies as answers if they help and unmark them if they provide no help, this will help others who are looking for solutions to the same or similar problem. Contact via my Twitter (Karen Payne) or Facebook (Karen Payne) via my MSDN profile but will not answer coding question on either.
    VB Forums - moderator
    profile for Karen Payne on Stack Exchange, a network of free, community-driven Q&A sites

    Thursday, October 11, 2018 8:00 PM
    Moderator