@KarthikGanesh,
There's lots of suggestions here. Hopefully this will clarify some of it:
- There is no standard Blue Prism VBO specifically for MS Access that I'm aware of. I'm guessing the Data - MS Access VBO shown above is something they developed themselves or found at another location.
- There are two VBOs available on the DX, and included in the standard BP install, that could be used to connect to MS Access. They are the Data - OLEDB VBO and the Data - ODBC VBO. The one you use governs which support files you'll need to install from Microsoft.
- For Data - OLEDB, you want to use the Microsoft Access Database Engine 2010 Redistributable (NOTE: There are 32-bit and 64-bit versions of the driver installer in this download. You probably want to install the 32-bit version since Blue Prism is a 32-bit client).
- For Data - ODBC, you've probably already got the necessary driver installed. You can check this by going to Start -> Run and typing ODBC. You should see options for the 32-bit and 64-bit ODBC Data Source Administrator utility. You want the 32-bit version. When that comes up, you should see an entry under the User DSN tab for MS Access Database. Now, if you want to use ODBC you'll have to configure either A User DSN or File DSN.
- Beyond the above, you have to have the correct Connection String defined. The Connection String you show in your screenshot suggests you're trying to use the ODBC provider to connect to your Access database. If that is the case, you need to use the Data - ODBC VBO. If you want to use the Data - OLEDB VBO, you need to change your Connection String to reflect that. It will look something like this:
"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=[YOUR DATABASE FILENAME AND PATH];"There could be more properties depending on how your database file is configured (ex. username and password).
Cheers,
------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------
.png){kind=link}
.png){kind=link}
.png){kind=link}