ApplicationIntent

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Aleksandr_73
Posts: 2
Joined: Fri 31 May 2019 11:53

ApplicationIntent

Post by Aleksandr_73 » Fri 31 May 2019 11:59

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
Devart Team
Posts: 332
Joined: Tue 03 Oct 2017 11:00

Re: ApplicationIntent

Post by Stellar » 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.
For example:

Code: Select all

MSConnection1.Options.ApplicationIntent := aiReadOnly;
Memo1.Lines.Add(MSConnection1.ConnectString);

Aleksandr_73
Posts: 2
Joined: Fri 31 May 2019 11:53

Re: ApplicationIntent

Post by Aleksandr_73 » Mon 03 Jun 2019 14:09

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

Stellar
Devart Team
Posts: 332
Joined: Tue 03 Oct 2017 11:00

Re: ApplicationIntent

Post by Stellar » 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.

Post Reply