sql - odbc

stampe
stampe Member Posts: 48
edited 2001-01-03 in Navision Financials
My Navision is 2.50 and running on a ms-sql server the problem ocur when i am trying to acsess the database with the sql sever odbc, I can se all the tables and chose fields from the tables but when I try to fininsh the ODBC wizard, this error ocur " Incorrect Syntax near 'Ltd'." this is when i am trying to acsess a table named "CRONUS International Ltd.$Customer" i think its either the "$" or the "." that causes the problem but what settings do i have to change to avoid this problem ?
If I try to acsess the database with ADO (OLE-DB) i get the same error with this syntax
"SELECT * From CRONUS International Ltd.$Customer"

while this syntax works

"SELECT * From [CRONUS International Ltd.$Customer]"

Pls. help

Thanks

Peter Nielsen

Comments

  • John_Tegelaar
    John_Tegelaar Member Posts: 159
    You are answering your own question. Because of the company name, you need to surround the table name with square brackets.

    Which ODBC wizard you are talking about? Are you trying to set up a System DSN? Which driver? What parameters have you used/set?

    John
  • stampe
    stampe Member Posts: 48
    Hello John

    I am talking about the wizard that is in ms excel where you chose an odbc connection,i dont have an english version of excel but thi´nk its the Data menu and then "Get external data" or something like that.
    I have made an system dsn where i use the sql server driver.

    It is correct that in ms query i can write the sql-statement and then get the data, but i was hoping that the wizard could do the work

    Peter

Categories