problems with datatypes Navision in SQL

[Hans]

Hello,

I have problems with retrieving some datatypes from the Navision
database in SQL Server 2000.
I use Linked Server with Navision ODBC driver(C/ODBC 2.60.02.5709)

When retrieving datatype 'Code' or 'Decimal' I get the following
errormessage:

OLE DB provider 'MSDASQL' returned an unexpected data length for the
fixed-length column '[MSDASQL].Nr_'. The expected data length is 21,
while the returned data length is 0.
OLE DB error trace [Non-interface error: Unexpected data length
returned for the column: ProviderName='MSDASQL',
TableName='[MSDASQL]', ColumnName='Nr_', ExpectedLength='21',
ReturnedLength='0'].

The query I use:

select Top 100*
from OPENQuery(NAVISION,'select Nr_ from klant')

When I ask for Naam and not Nr_ then it works properly

Regards,

Hans de Korte
ProMinent Verder Holland