Question

4
Replies
504
Views
BenC5447 Member since 2017 1 post
Westpac Group
Posted: September 25, 2017
Last activity: September 27, 2017
Closed
Solved

SQLQuery Component - Keyword not supported: 'application intent'.

Hi all,

I'm working on a solution to query data from an SQL database and use the data to perform other operations.

When I configure and test the connection, the connection is successful, but I'm getting some errors when trying to save the data link:

Using these settings:

I have also tried different SQL providers and added "ApplicationIntent=ReadOnly" to the Extended Properties with no luck.

I can successfully test and save the configuration for other DBs, but this one needs to be "ReadOnly" in the ApplicationIntent property, so I can't use the Data link defaults.

Has anyone seen any similar problems using the SQLQuery Component?

Thanks and regards,

Ben

Robotic Process Automation
Moderation Team has archived post
Share this page LinkedIn