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:
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
Accepted Solution
Westpac Group
AU
Only way I was able to get it to work was by creating the connection in the "Connection String" field:
Provider=SQLOLEDB.1;Data Source= Proprietary information hidden,1435;Integrated Security=False;User ID=someuserID;Password=***********;Connect Timeout=30;Encrypt=False;TrustServerCertificate=True;MultiSubnetFailover=False;ApplicationIntent=ReadOnly
Pegasystems Inc.
US
I did some digging around and it looks like this exception is thrown in other C# apps as well. If you use the same connection data and query externally from OpenSpan, does this same exception get thrown?
Pegasystems Inc.
US
Have you tried changing your target framework? Perhaps the framework you're targeting does no recognize the ApplicationIntent attribute.
Accepted Solution
Westpac Group
AU
Only way I was able to get it to work was by creating the connection in the "Connection String" field:
Provider=SQLOLEDB.1;Data Source= Proprietary information hidden,1435;Integrated Security=False;User ID=someuserID;Password=***********;Connect Timeout=30;Encrypt=False;TrustServerCertificate=True;MultiSubnetFailover=False;ApplicationIntent=ReadOnly