Adds to the connection string the parameters needed by the user.
Generators: .NET, .NET Framework
Level: Data Store
There is no default value for this property.
For more information on the attributes supported by the driver used, their meaning, and their values, please refer to the following specific links for each DBMS:
- For SQL Server, see the list of available values in this link.
- For Oracle, a list of values can be found in this link.
- If you use DB2, you can see the available options in this link.
In addition, SQL Server supports authentication with AD (Active Directory) in the Azure SQL database.
Authentication methods can be as follows:
- Active Directory Password
- Active Directory Integrated
- Active Directory Interactive
- Active Directory Service Principal
- Active Directory Device Code Flow
- Active Directory Managed Identity
- Active Directory MSI
- Active Directory Default
Note that you can add attributes found in the linked page table, as long as they do not conflict with the properties previously specified for the DBMS in GeneXus.
Avoid duplicates or values that may cause configuration problems.
Also, keep in mind that attributes must be separated by semicolons.
If you want to use the "Active Directory Password" authentication method in Azure SQL, the property value must be similar to the following:
Server=demo.database.windows.net; Authentication=Active Directory Password; Encrypt=True; Database=testdb; User Id=user@domain.com; Password=***
With SQL Server, the Additional connection string attributes could be:
Encrypt=true;Max Pool Size=40
These attributes are separated by semicolons and allow you to customize the connection according to your specific needs.
However, remember not to include "database=bd_name" in the connection string. For example, this would be incorrect:
Encrypt=true;Max Pool Size=40;database=bd_name
To apply the corresponding changes when the property value is configured, execute a Build with this Only of the object.
HowTo: Configure the maximum pool size for ADO.NET