Too many parameters in the parameter collection.

Hope

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. 

Prasanta_Pal

If you could elaborate a bit more what you are trying to achieve would help us find the solution.

K_Y

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.