Instead of named parameters, the ODBC .NET Provider uses positional parameters that are marked with a question mark (?) in the syntax of the command text.

Please make sure that UseNativeQuery to false(0) in the odbc connection string as they have mentioned in the https://docs.databricks.com/en/_extras/documents/Simba-Apache-Spark-ODBC-Connector-Install-and-Confi... . that when this option is enabled(1) the parameterized query won't work.