470,833 Members | 1,464 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,833 developers. It's quick & easy.

problems with datatypes Navision in SQL


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

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

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',

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


Hans de Korte
ProMinent Verder Holland
Jul 20 '05 #1
0 2820

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Andrew Gordon | last post: by
4 posts views Thread by Xavi | last post: by
reply views Thread by zhilan | last post: by
reply views Thread by Navision Recruiter | last post: by
reply views Thread by anna | last post: by
reply views Thread by mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.