SQL and ODBC

PascalFan
PascalFan Member Posts: 4
edited 2001-03-01 in Navision Financials
Has anyone else seen this, and is there a known work-around?

We're trying to open a Navision SQL database using ODBC in Access. It seems to have trouble with Navision's table and field names. Some tables open without difficulty but those with "No." fields fail. The usual error message is "Syntax Error Near ','". With the non-SQL database, there's a translation step that lets me translate spaces and periods and other special chars into underscores (or nothing). Is there something similar for SQL databases? Is there a different driver that works better. I would really be interested in hearing from someone who has experienced this problem and has attempted to resolve it. Thanks very much.

PascalFan
Chicago, IL USA

Comments

  • Fredrik_Gustafsson
    Fredrik_Gustafsson Member Posts: 14
    I did create views in SQL-server for the tables of interest. In the views I removed all periods.
    Then Access can read the views without problem.

    Fredrik
  • julietlau
    julietlau Member Posts: 1
    You can go to Navision Website and download their ODBC driver. Select "Options" after you get into the ODBC setup window. Make sure the ¡§Identifiers¡¨ is set with "ALL Except DOT".

    Juliet Lau
    Apex Computer Systems, Inc

Categories