ApplicationIntent

[Aleksandr_73]

Hi!
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

[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;
Memo1.Lines.Add(MSConnection1.ConnectString);

[Aleksandr_73]

I used prAuto before. After I changed provider to prDirect, it works properly and ConnectString shows ApplicationIntent=ReadOnly.
Thank you

[Stellar]

Glad to see that the issue was resolved.
Feel free to contact us if you have any further questions about our products.