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
1 Answer, 1 is accepted
0
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
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