Question

1
Replies
1054
Views
Close popover
Michael Tan (tanm1)
PEGA
Sr. System Architect
Pegasystems Inc.
JP
tanm1 Member since 2016 39 posts
PEGA
Posted: July 20, 2018
Last activity: July 24, 2018
Closed

Pega Robotics Studio: connect to MS Access database

Following the example in this post, I am trying to establish a connection to a MS Access database and select the contents of one table: https://community1.pega.com/community/pega-support/question/robotics-studio-integrate-access-db However, despite selecting "Access Database Engine" (refer '1set.png'), completing the settings and successfully testing the connection (refer '2test.png'), when I exit out of the data link property window the connection string has referred to "SQL Server" (refer '3revert.png'). Opening the data link property popup again, sure enough the data provider has been automatically forced back to "SQL Server" (refer '4revert.png') and test connection now fails. Why does the provider revert to SQL Server? Or is there another/better way to connect to an MS Access table?

Robotic Process Automation
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.