OLEDB Usage

varshakanthikar — Tue, 15 Sep 2020 12:54:00 GMT

Hi ,
I had gone through OLEDB Guide provided by blue prism Portal. While setting Connection I am getting error as "could not execute code stsge because exception thrown by code stage: format of the initializing string does not confirm to a specification starting index 152"

I Provided connection string as "

Provider=Microsoft.ACE.OLEDB.12.0;Data Source="D:\Blue Prism\Business Planning and operations\Pipeline Tracker Base Creation\TSU-Pipeline-Tracker.xlsx";Extended Properties="Excel 12.0 Xml;HDR=YES;"

still not able to set connection using data-OLEDB VBO

Thanks and Regards,
Varsha Kanthikar

------------------------------
varsha kanthikar
project trainee
persistent systems limited
America/Indiana/Indianapolis
------------------------------

RE: OLEDB Usage

gmarquez — Tue, 15 Sep 2020 13:29:00 GMT

Hi Varsha,

This usually points to an error with your connections string. From our documentation, I think you need to remove the XML in extended properties and add Extended Properties - Extended Properties="Excel 12.0;HDR=YES;"; From here: http://portal.blueprism.com/customer-support/support-center#/path/1416707612

Once you reconfigure your connection string, make sure to test it outside of Blue Prism to make sure it works correctly.

I hope that helps!

------------------------------
Gabe Marquez
Technical Support Engineer
Blue Prism
------------------------------

topic RE: OLEDB Usage in Product Forum

OLEDB Usage

RE: OLEDB Usage