Page 1 of 1


Posted: Fri 31 May 2019 11:59
by Aleksandr_73
I've used the property of TMSConnection.Options.ApplicationIntent setting it to ixReadOnly. But DBA don't see this option in the connections to databases. I've tried to add this one to the TMSConnect.ConnectString AS ...;ApplicationIntent=ReadOnly, it doesn't set to the ConnectString. How does it work and does it work?

SDAC 8.2.8 for RAD Studio 10.2

Re: ApplicationIntent

Posted: Mon 03 Jun 2019 12:48
by Stellar
Please specify which provider you are using to connect to MS SQL Server.
When you set the aiReadOnly value for the ApplicationIntent parameter, SDAC adds the name and the value of the parameter ("Application Intent=aiReadOnly") to the ConnectString property.
For example:

Code: Select all

MSConnection1.Options.ApplicationIntent := aiReadOnly;

Re: ApplicationIntent

Posted: Mon 03 Jun 2019 14:09
by Aleksandr_73
I used prAuto before. After I changed provider to prDirect, it works properly and ConnectString shows ApplicationIntent=ReadOnly.
Thank you

Re: ApplicationIntent

Posted: Tue 04 Jun 2019 06:41
by Stellar
Glad to see that the issue was resolved.
Feel free to contact us if you have any further questions about our products.