[FEATURE] Ability to check if a connection has been closed

[martinstuder]

Is your feature request related to a problem? Please describe.

Currently, checking whether a connection has been closed requires a workaround such as issuing a getinfo(...) request and intercepting an InterfaceError if the connection has been closed.

Describe the solution you'd like

Ideally, it would be possible to directly check if a connection has been closed, e.g. through a property closed.

Describe alternatives you've considered

Alternatives considered:

• issuing a getinfo(...) request and intercepting InterfaceError
• attempting to create a cursor and intercepting InterfaceError

[bewithgaurav]

Hey @martinstuder
Thanks for creating this issue. We appreciate your effort in using mssql-python driver and suggesting this enhancement.
We will check the usage of connection closed property in other drivers as well, and get back on this.
Thanks again for sharing your feedback!

[bewithgaurav]

Quick clarification: the closed property would indicate whether close() was explicitly called, not whether the connection is healthy/alive. So if a timeout or network issue breaks the connection, closed would still be False until you explicitly call close().

This matches how other drivers work - to detect broken connections you'd still need to try an operation and catch exceptions.

[jahnvi480]

@martinstuder We have added this property in connection class now, PR has been merged. You will be able to use it once we do our release this week.
Thanks for trying out our driver, and sharing your feedback.