topic RE: OLEDB setup for DB2 in Product Forum

OLEDB setup for DB2

mnunn — Mon, 14 Oct 2019 17:44:00 GMT

Hi,

Does anyone tried establishing a connection between blue prism and DB2 through OLEDB. If yes, could you share details on connection string for DB2.

Regards,
Manoj

------------------------------
Manoj kumar Nunna
RPA Team Lead
Tyson Foods
Asia/Kolkata
------------------------------

RE: OLEDB setup for DB2

jegendra — Tue, 15 Oct 2019 00:11:00 GMT

Hi Manoj,

The connection string would be in the following format:

------------------------------
Jega Avinasinathan
Customer Support Engineer
Blue Prism
------------------------------

RE: OLEDB setup for DB2

mnunn — Tue, 15 Oct 2019 04:58:00 GMT

Hi,

Thank you. I have added provider to connection string as Provider=DB2OLEDB. and it is throwing below error,
Provider=DB2OLEDB;Server=xxxxxxx:port;Database=xxxx;UID=xxxxx;PWD=xxxxx;

Internal : Could not execute code stage because exception thrown by code stage: The host resource could not be found. Check that the Initial Catalog value matches the host resource name.

------------------------------
Manoj kumar Nunna
RPA Team Lead
Tyson Foods
Asia/Kolkata
------------------------------