[Microsoft][ODBC Text Driver] Syntax error in FROM clause.

Problem

Problem Number Error Error number -3989587 DMS-E-GENERAL, A General Exception has occurred during operation 'prepare request'. DMS-E-DBPARSER, The underlying database detected an error during processing of the SQL request. [Microsoft][ODBC Text Driver] Syntax error in FROM clause. when querying an ODBC datasource using the Microsoft ODBC Text Driver. Solution Description This error is due to an issue with the ODBC driver. Microsoft have documented this issue in their Knowledge Base articles #Q124322, Q125959 and Q124319. Please contact Microsoft for further information on this issue. As a workaround it may be possible to Qualify the Tables Less in the Catalog Tables dialog window. It may also be necessary to change the delimiter type in the ODBC drivers options, and to use Escape Metacharacters when retrieving the data. This option is also set in the Options for the ODBC driver. The problem is due to the driver not supporting quoted schema's or tables thus to eliminate the problem the attach must be made using the connection parameter DELIMIT=COL. Microsoft offers the following as a workaround. Please contact Microsoft for further information on this technique. These workarounds are not set within Impromptu but are for the Driver. Method 1: Name the range something other than "Database" or "Table." Method 2: If you are accessing data from a Microsoft Excel 5.0 workbook that contains a global range named "Database" or "Table," define it as a local range name, such as "Sheet1!Database." Note that making the name a local one will cause the table name to be displayed with the sheet name and then the range name: Sheet1!Database. Method 3: Add brackets ([) around the words "Database" or "Table." For example, to select all records from a table called Database, follow these steps: a. In Microsoft Query, click the SQL button on the toolbar. This displays the SQL dialog box. b. In the dialog box, type the following SQL statement: SELECT * FROM [Database] c. Choose OK. A message will appear stating that the query cannot be represented graphically. d. Choose Yes to continue. This displays only the Data pane in the query window.