---
title: "system.db.setDatasourceMaxConnections"
description: "Sets the Max Active and Max Idle parameters of a given database connection."
---

# system.db.setDatasourceMaxConnections

> Sets the Max Active and Max Idle parameters of a given database connection.

This function is used in **Python Scripting**.

## Description

Sets the *Max Active* and *Max Idle* parameters of a given database connection.

## Client Permission Restrictions

[Permission Type](ignition-modules\vision\vision-project-properties\vision-project-properties.md#vision-permissions-properties): Datasource Management

Client access to this scripting function is blocked to users that do not meet the role/zone requirements for the above permission type. This function is unaffected when run in the Gateway scope.

## Syntax

`system.db.setDatasourceMaxConnections(name, maxConnections)`

### Parameters
Type | Parameter | Description 
------- | ------- | -----
String| `name` | The name of the database connection in Ignition.
 Integer| `maxConnections` | Sets the *Max Active* and *Max Idle* parameters of a given database connection.

### Returns
Nothing

### Scope
Gateway, Vision Client, Perspective Session

## Code Examples

```python title="Code Snippet - Setting the Max Connections of a Data Source"
# Example 1: Enable a connection
system.db.setDatasourceMaxConnections("MySQL", 20)
```