Creating views in SQL 7.0 to navision db

Hi! I´m trying to create views in a SQL 7.0 server to a linked navision database throug a C/ODBC dsn but fails to do so. The error message is MSDASQL returns an unexpected data lenght for the fixed-length column [linkedservername]…[tablename].fieldname. The expected data length is 21, while the return data is 2. This problem only occurs when im trying to access data from a field of the CODE datatype. Is there any solution to this problem. Best regards, Andreas Åsander, EnterNet Technologies Edited by - Andreas_Enternet on 2/15/01 9:42:34 AM