5 Replies Latest reply: Jun 8, 2010 10:37 AM by kkelly RSS

    Navision 4.0 ODBC

    RudolfsCiemins

      Hello!

      I have to get data from Navision 4.0 native database. I use the ODBC which came along with NAV installation.

      I can connect to the NAV database, see tables and fields... I created a simpe query with the designer...

      LOAD "Entry No_",
      "Item No_",
      "Posting Date";
      SQL SELECT "Entry No_",
      "Item No_",
      "Posting Date"
      FROM "Value Entry";

      LOAD "No_";
      SQL SELECT "No_"
      FROM Item;

      Value Entry data loads fine... But Item data fails...

      SQL Error:[Simba][SimbaEngine ODBC Driver]Invalid column name: 'No_'.
      SQL Scriptline:
      SQL State:S0022
      SQL SELECT "No_"
      FROM Item

      For a SIB I simply copied all required tables to an Excel file an load from there. But it isn't a solution in a long term...

      So... How to get data from Navision?