Question

4
Replies
525
Views
Close popover
Ben Camareno (BenC5447)
Westpac Group

Westpac Group
AU
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