I try to connect to Navision DB from VB using C/ODBC, but I have one problem about SQL statement. For example, I use following statement “Search * From Job”, it works. If I use “Search * From Sales Header”, I get error msg “Table does not exist” because there is a space in talbe name. I have tried four type of Identifiers setting at C/ODBC options. Still cannot work. Any solution?
Try SELECT * FROM “Sales Header”
Otherwise, you can try to set as identifier in c/ODBC options “all except space” and then substitute spaces with underscores in your query.
Use: sql = “SELECT * FROM ““Sales Header”””