468,306 Members | 1,166 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

problems with datatypes Navision in SQL

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
Jul 20 '05 #1
0 2761

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 NPC403 | last post: by
reply views Thread by Teichintx | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.