This page documents the global attributes and functions available directly from the mssql_python module. These apply across all connections and cursors created using mssql_python.

Returns the global settings object.

import mssql_python settings = mssql_python.get_settings() print(settings.lowercase) # False print(settings.decimal_separator) # "."

Sets the decimal separator character used when parsing NUMERIC/DECIMAL values.

Args

• separator (str): Must be a single non-whitespace, non-control character string.

Raises

• ValueError: If the input is empty, longer than one character, whitespace, or a control character.

import mssql_python # Change separator to comma mssql_python.setDecimalSeparator(",")

Returns the current decimal separator.

import mssql_python sep = mssql_python.getDecimalSeparator() print(sep) # "."

Configures the connection pooling behavior.

Args

• max_size (int): Maximum number of connections in the pool.
• idle_timeout (int): Seconds before idle connections are closed.
• enabled (bool): Enable (True) or disable (False) pooling.

import mssql_python # Enable pooling with defaults mssql_python.pooling() # Enable pooling with custom values mssql_python.pooling(max_size=50, idle_timeout=300) # Disable pooling mssql_python.pooling(enabled=False)

⚠️ Security & Usage Notes

• Be careful when changing the decimal separator: setting it incorrectly may cause numeric parsing issues or inconsistent behavior across environments.
• When enabling connection pooling, ensure proper sizing of max_size and idle_timeout to avoid resource exhaustion or stale connections in long-running applications.