I got the following error in my Grails app but Parameter 32 doesn’t make sense to me. Then I googled and found why. I copied the answer from stackoverflow.com.
Exception Message: The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 32 (""): The supplied value is not a valid instance of data type datetime.
“why I’m getting an error with the 12th parameter(When I only have 9 columns)” – A pyodbc .execute() statement is translated by the ODBC driver into an sp_prepexec call and sp_prepexec takes three (3) additional parameters (handle, params, and stmt) before the beginning of the bound parameters.