asked on Python with pyodbc and SQL Server
I am building a query batch of multiple queries to be executed from python in sql server like:
update tbl1 set... where...
insert tbl2 values...
update tbl3 set... where...
If the insert causes a PK violation the execution of the batch does not report anything. It is like the execution is successful. However the same query executed directly in SQL server will fail.
How can I catch the error?
update tbl1 set... where...
insert tbl2 values...
update tbl3 set... where...
If the insert causes a PK violation the execution of the batch does not report anything. It is like the execution is successful. However the same query executed directly in SQL server will fail.
How can I catch the error?
Programming Languages-Other
Last Comment
Zberteoc
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
I am not sure what happened but now I get the error after a combination of try..catch in python with try..catch with raiserror in SQL that I execute. Anyway I consider the question answered.
ErrNo: HY007
ErrMsg: [HY007] [Microsoft][ODBC SQL Server Driver]Associated statement is not prepared (0) (SQLNumResultCols)
I also tied to wrap the SQL query batch in TRY ... CATCH and if there is error (and there is PK violation) I use RAISERROR SQL statement to bring it back in Python.
However in this case the RAISERROR is completely ignored by Python and it won't report error unless the first command in the query batch produces it!
I want to catch the real error message, even if produced in the middle of the batch and bring it back to python to log it.