Question
Soprasteria
CH
Last activity: 19 Jul 2018 15:54 EDT
Robotics Studio integrate with Access DB
I am working on the sample POC and I would like to know the steps for integrating with Access 2010 DB
Accepted Solution
Soprasteria
CH
Open the Connection String in the Properties panel
1. Provider Tab -> Select the Providers OLE DB Providers Select the "Microsoft Office 12.0 Access Database Engine OLE DB Provider" and on the
2. Connection Tab -> Provide the Data Source Name as Path of the MS ACCESS db file (Ex:C:\......\filename.accdb) and
3. click on the test connection Then it should say the Connection Successful.
Pegasystems Inc.
US
You can use the OleDBQuery component for that.
Soprasteria
CH
using the OleDBQuery component. when i am configuring the connection string. i am getting the following error.
The .Net Framework Data Provider for OLEDB (System.Data.OleDb) does not support the Microsoft OLE DB Provider for ODBC Drivers (MSDASQL). Use the .Net Framework Data Provider for ODBC (System.Data.Odbc).
Accepted Solution
Soprasteria
CH
Open the Connection String in the Properties panel
1. Provider Tab -> Select the Providers OLE DB Providers Select the "Microsoft Office 12.0 Access Database Engine OLE DB Provider" and on the
2. Connection Tab -> Provide the Data Source Name as Path of the MS ACCESS db file (Ex:C:\......\filename.accdb) and
3. click on the test connection Then it should say the Connection Successful.