cancel
Showing results for 
Search instead for 
Did you mean: 

OLEDB - Data

Sheng_QuanHo
Level 3
​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
------------------------------
2 REPLIES 2

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

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

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