locked
Linked server to Progress db RRS feed

  • Question

  • User-1240674726 posted

    im trying to retrieve data from Progress 10.1B, using a ODBC (DataDirect Driver) in a MSSQL linked Server, i get the following error:

    OLE DB provider "MSDASQL" for linked server "OE_LKS_v2" returned message "[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Column msg in table PUB.K_SYS_MESSAGE has value
    exceeding its max length or precision.".


    Also, in my .NET app, when using a DataReader for the same query, the error mesasge is a bit different but (i guess) it means pretty much the same:

    "String data, right truncated. Error in parameter 1"

    anyone can help me on how to solve this problem??

    Thanks in advance!

    Wednesday, January 11, 2012 12:54 PM

Answers

  • User-1240674726 posted

    Guys.... we found it! :)

    th problem was when exporting the code from a MSSQL db, some column value width property was too  short, so when columns were created in Progress those fields could not been retrieved if its values legth was wider.

    it was solved by re-creating those tables and redifined te fileds width! here an example:

    ADD FIELD "FIELD_DESC" OF "K_CRE_BASE_PRODUCTS" AS character
      FORMAT "X(50)"
      INITIAL ?
      POSITION 4
      MAX-WIDTH 100
      LENGTH 50
      ORDER 30

    in this case, the column being created is named FIELD_DESC, its previous max-width was 16.

    Hope this helps anyone whos having same problem!!

    Cheers!Tongue out

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, January 12, 2012 5:55 AM