Page 1 of 1
Posted: Fri 31 May 2019 11:59
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
Posted: Mon 03 Jun 2019 12:48
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.
Code: Select all
MSConnection1.Options.ApplicationIntent := aiReadOnly;
Posted: Mon 03 Jun 2019 14:09
I used prAuto before. After I changed provider to prDirect, it works properly and ConnectString shows ApplicationIntent=ReadOnly.
Posted: Tue 04 Jun 2019 06:41
Glad to see that the issue was resolved.
Feel free to contact us if you have any further questions about our products.