Blue Prism Product

last person joined: 5 hours ago 

Chat about Blue Prism products
Expand all | Collapse all

OLEDB - Data

  • 1.  OLEDB - Data

    Posted 28 days ago
    ​Hi,

    I am trying to run an update SQL using the Get Connection action in Data - OLEDB VBO.  It's failing as I believe it's expecting a result set so I create an Update action.  It's completing with error, but it is not actually updating the data.  (See attached docs).  Can you please advise what may be wrong?  Also, is there a new Data - OLEDB VBO that has Execute action similar to SQL Server VBO.

    Thank you

    ------------------------------
    Sheng Quan Ho
    Vice President
    Jennison
    America/New_York
    ------------------------------

    Attachment(s)

    docx
    oledb.docx   40K 1 version


  • 2.  RE: OLEDB - Data

    Posted 26 days ago
    Hi,

    It might help if you could post the error message that you are getting. On another note there is a utility available on DX to connect to SQL Server and here is the link https://digitalexchange.blueprism.com/dx/entry/9648/solution/blue-prism-sql-server-utility

    ------------------------------
    Shashank Kumar
    DX Integrations Partner Consultant
    Blue Prism
    Singapore
    +6581326707
    ------------------------------



  • 3.  RE: OLEDB - Data

    Posted 26 days ago
    Thanks for reply.  I was able to obtain latest OLEDB VBO and use Execute action.​

    ------------------------------
    Sheng Quan Ho
    Vice President
    Jennison
    America/New_York
    ------------------------------