topic OLEDB - Data in Product Forum

OLEDB - Data

SHo — Wed, 30 Sep 2020 12:16:00 GMT

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

RE: OLEDB - Data

shashank.kumar280 — Thu, 01 Oct 2020 16:40:00 GMT

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

RE: OLEDB - Data

SHo — Thu, 01 Oct 2020 21:52:00 GMT

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

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