Skip to main content

Too many parameters in the parameter collection.

  • June 25, 2014
  • 2 replies
  • 6 views
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.

    2 replies

    Prasanta_Pal
    Forum|alt.badge.img
    • Prasanta_Pal
    • Participating Frequently
    • June 27, 2014
    If you could elaborate a bit more what you are trying to achieve would help us find the solution.

    K_Y
    • K_Y
    • New Participant
    • September 29, 2021

    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.

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement