Error in passing a Date as parameter in Query designer

2 posts, 0 answers
  1. ranjith
    ranjith avatar
    1 posts
    Member since:
    Nov 2018

    Posted 24 Mar Link to this post

    Hello,

    I am trying to pass two date parameters to my query in Query designer but i getting below progress error

     

    ERROR[22001][DataDirect][ODBC Progress Openedge Wire Protocol driver]String data, right truncated.Error in parameter 3.

    Whereas it is working for other data types like character, integer and logical.kindly help me to resolve this issue

     

  2. Silviya
    Admin
    Silviya avatar
    350 posts

    Posted 27 Mar Link to this post

    Hello Ranjith,

    What is the currently installed version of ODBC Oracle Wire Protocol? I researched and found out that this is a common issue. Please check the following articles and the resolutions provided (likely it is a bug which is already fixed in the next version of the product):
    SQL: ERROR "STRING DATA, RIGHT TRUNCATED. ERROR IN PARAMETER 2" EXECUTING AN INSERT STATEMENT.
    "STRING DATA, RIGHT TRUNCATED" ERROR WHEN SELECTING DATE FIELD
    OPENEDGE 10.2B ODBC DRIVER RETURNS ERROR "STRING DATA, RIGHT TRUNCATED. ERROR IN PARAMETER 1" WHEN PARAMETER VALUE EXCEEDS SQL WIDTH

    Best Regards,
    Silviya
    Progress Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top