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.
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.