Execute SQL Server Stored Procedure

[brijeshkumar_77]

I need to execute a Stored procedure in SQL Server and capture all Print statements inside the SP. In addition to this, for other SP's i want to access the result set of the Stored Procedure. I have tried using few libraries like pyodbc, jaydebeapi etc. but none worked

db_conn = pyodbc.connect(connection_string)
sql = """\
DECLARE @RC int;
SET ANSI_WARNINGS OFF;
SET NOCOUNT ON;
{Call [dev_1].[sp_testing] (?, ?, ?)};
SELECT @RC AS rc;
"""
values = (parm1, parm2, parm3)
cursor = db_conn.cursor()
cursor.execute(query_string, value)
rows = cursor.fetchall()

Can anyone suggest how can achieve this. Is there any other library that i can use to achieve this. Appreciate your help with this. Thanks

---

It is now working.
I missed to put the commit
db_conn.commit()
it solved the issue.