tanm1 Member since 2016 39 posts
Posted: 2 years ago
Last activity: 2 years 2 months ago

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:… 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
Share this page LinkedIn