[Answered ]-Stored procedure in PyODBC writes: not all arguments converted during string formatting

1👍

This errors occurs because the parameters you are passing don’t match the defined types on the database side in SQL Server.

Are @id_workplace, @personal_number and @id_activity all integers? If so, are the Python variables id_workplace, personal_number, and id_activity all integers? What are the values of the Python variables? If any of them are None, you’ll need to make sure that the corresponding database variable allows NULL.

Leave a comment