Problem When Connecting OBDC

haja12_aamshaja12_aams Member Posts: 13
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


  • pltplt Member Posts: 1
    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...
  • FabermanFaberman Member Posts: 24

    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.

Sign In or Register to comment.