Precision Exceeded the Allowable Maximum

For questions and postings not covered by the other forums
scott.melhop
Posts: 1
Joined: Thu Feb 02, 2017 1:52 pm

Precision Exceeded the Allowable Maximum

Postby scott.melhop » Thu Feb 02, 2017 2:01 pm

I have set up a Linked Server to a Greentree Jade Database. I can return data but run into trouble with some data types that cause the error shown below. Is there a way to convert/cast the queried column in order for it to be displayed in SQL Management Studio. I have tried the SQL functions CAST and CONVERT but this doesn't work.

SELECT *
FROM OPENQUERY(GREENTREE, 'SELECT gti_FcAmount FROM JCLineItem')

Msg 7354, Level 16, State 1, Line 2
The OLE DB provider "MSDASQL" for linked server "GREENTREE" supplied invalid metadata for column "gti_FcAmount". The precision exceeded the allowable maximum.

Return to “General Discussion”

Who is online

Users browsing this forum: No registered users and 3 guests

cron