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