Problem When Connecting OBDC

haja12_aams

Im using Navision 5 and im im trying to connect the ITEM table through OBDC but i got the following error message....


Too Many Columns. Some columns are Omitted


But the table contains only 50 fields and 5000 records. Any one can help me

Note : I have installed NODBC with original license..

Thanks in Advance

plt

There is a change you can make to the Windows registry settings of the driver to increase the number of columns that it returns.

Open the Windows Registry Editor and search for a string value called MaxColSupport, and assign it a number no greater than the limits given for column ex. 500 and then try again...

Faberman

Hi,

Would you be so kind as to look at my "MS Access queries don't work with parameters using NODBC" post?

I have searched all over for a solution but found nothing.

Any advice you can give will be greatly appreciated.

Thanks.