ODBC

The 'ODBC Data Source Name' property specifies the DSN configured in the system's ODBC Data Source Administrator. This value is required for establishing a connection via ODBC.

• Select from the list of available DSNs, which are populated from the system configuration.
• Used in conjunction with 'User Name' and 'Password' to build the connection string.
• The DSN must be properly configured and accessible on the machine where Grooper is running.

Example:
MySqlDsnOracleDsn

The 'Connection Timeout' property controls how long Grooper will wait when attempting to establish a connection to the database server. If the connection cannot be made within the specified time, the attempt is aborted and an error is generated.

• Increase this value if connecting to remote or slow servers.
• Decrease it to fail fast in environments where quick feedback is preferred.

Example:
Set to 30 to allow up to 30 seconds for the connection to succeed.

The 'User Name' property specifies the account used to authenticate with the database server. If both 'User Name' and 'Password' are left blank, Grooper will use Windows Authentication (integrated security), which is recommended in environments where Active Directory is available and security policies require it.

• Enter a user name for SQL authentication or other explicit login scenarios.
• Leave blank to use the credentials of the Windows user running the Grooper service or application.

Example:
dbuser

The 'Password' property is used in conjunction with 'User Name' for explicit authentication to the database server. The password is stored in encrypted form and is never displayed in plain text in the UI.

• Leave blank to use Windows Authentication.
• Enter a password only when required by the database server and security policy.

Security Note:
The password is encrypted for storage, but always follow best practices for credential management.

The 'Connection String' property displays the full connection string used to connect to the database, with sensitive information such as passwords masked or removed for security. This allows you to verify the configuration without exposing credentials.

• Use this property to confirm that all required parameters are present and correct.
• The actual connection string used at runtime may include additional provider-specific options, depending on the derived class.

Example:
Server=myserver;Database=mydb;User Id=dbuser;Password=*****;Timeout=30;