OLEDB - Data

[Sheng_QuanHo]

​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
------------------------------

[shashank.kumar280]

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
------------------------------

[Sheng_QuanHo]

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

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