Too many parameters in the parameter collection.
I am facing some issue in vertica 7 ADO.NET driver. Issue is specifically related to parameter. Some time i cannot execute a query with more than one parameter. it show an error like 'Too many parameters in the parameter collection.', Can anyone know the reason of this issue.
0
Comments
In most cases, this error occurs when the SQL contains a "--" comment. In some cases, this error does not occur, and the cause is unknown.
When I changed the comment of the SQL where the error occurred from "--" to "/* */", it started to work correctly.
The error does not occur in normal SQL, but it occurs when VerticaParameter is used.