Official Content

Adds to the connection string the parameters needed by the user.

Scope

Generators: .NET, .NET Framework
Level: Data Store

Description

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:

  1. Active Directory Password
  2. Active Directory Integrated
  3. Active Directory Interactive
  4. Active Directory Service Principal
  5. Active Directory Device Code Flow
  6. Active Directory Managed Identity
  7. Active Directory MSI
  8. 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.

Samples

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

How to apply changes

To apply the corresponding changes when the property value is configured, execute a Build with this Only of the object.

See Also

HowTo: Configure the maximum pool size for ADO.NET

Last update: February 2024 | © GeneXus. All rights reserved. GeneXus Powered by Globant