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
ApplicationIntent
Re: ApplicationIntent
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:
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);
-
- Posts: 2
- Joined: Fri 31 May 2019 11:53
Re: ApplicationIntent
I used prAuto before. After I changed provider to prDirect, it works properly and ConnectString shows ApplicationIntent=ReadOnly.
Thank you
Thank you
Re: ApplicationIntent
Glad to see that the issue was resolved.
Feel free to contact us if you have any further questions about our products.
Feel free to contact us if you have any further questions about our products.