Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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. 

Comments

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

  • K_YK_Y
    edited September 29

    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.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.