Problem When Connecting OBDC

haja12_aams
haja12_aams Member Posts: 13
edited 2007-12-10 in NAV/Navision Classic Client
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

Comments

  • plt
    plt 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...
  • Faberman
    Faberman Member Posts: 24
    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.

Categories