Error in Numeric Overflow

[di_tw]

I am using Linked Server (Ms. SQL 2000) to connect OpenEdge 10.0B (ODBC). I got the error messages:

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [DataDirect][ODBC OPENEDGE driver]Numeric overflow. Error in column 2.]
[OLE/DB provider returned message: [DataDirect][ODBC OPENEDGE driver]Error in row.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IRowset::GetNextRows returned 0x80004005: ].

This error cannot show decimal value, but if I am using Ms. Access it's working.

Does anyone know and have solution for this problem ?

 

[netrista]

First, make sure your Progress version is certified for use with SQL2K Linked Servers. I know that only the OpenEdge 10.1 series is certified for use with SQL2005. I don't know about SQL2K.

Second, have you done any type of clientside ODBC tracing to see how the problem columns are being described/bound? And, do you have access to the data definitions dump or schema for the table so that you can see the precise description of what are apparently decimal data types?

Finally, do you have an OLE DB test app that would allow you to issue the same query outside of the Linked Servers interface so that you can determine whether the problem is generalized to all OLE DB apps or only Linked Servers?

Best regards,
Netrista Khatam
Technical Services Manager
OpenLink Product Support