Error in running SQL query

[siddheshmane]

Hello everyone,

I need help with this error that i am getting. Please find screenshot of the error attached. This has been occuring since a couple of weeks now. I am connecting to a NAV database.

Thank you for your help.

Siddhesh Mane.

[sasiparupudi1]

It says too many columns in the query.. may be there is some restriction on the select?/

try commenting some of the columns and see if the error disappears

[siddheshmane]

Hi Sasidhar,

Thanks for helping me out. I am only loading one column "No_" in the select statement. It still gives me this error.

[jerifortune]

Could you try another field?  Also try running the select statement on the database.

[tamilarasu]

I am not sure about this but below link explain the reason and fix.

https://support.microsoft.com/mk-mk/help/2534952/the-value-in-the-maxcolsupport-property-of-the-nodb...

[siddheshmane]

The problem is I do not have access to it, It's a Navision ERP database. I also tried a different column. it seems like the error occurs only when i query this table. The other tables when I try querying, it works fine.