BUG: Dbase or FoxPro: Fox Memo Select Stopped by Dbase (119811)

MORE INFORMATION

1. Connect to any ODBC Dbase datasource.
2. Create any form of Dbase table with the ODBC Dbase driver, Then free the statement handle used for this operation with SQLFreeStmt() but do not call SQLDisconnect().
3. Connect to an FoxPro ODBC datasource that provides access to a FoxPro table containing at least one memo field.
4. Attempt to execute a SQL SELECT query on the FoxPro table containing the memo field via SQLExecDirect() or attempt to prepare such a statement with SQLPrepare(); either way, the same problem will be created.
   
   The error message received is:
   [Microsoft][ODBC Single-Tier Driver][ODBC File Library]General Isam error.
   [Microsoft][ODBC Single-Tier Driver]Unable to open table: <table_name>.

1. Define a Dbase and a FoxPro ODBC datasource. You will need to create a Fox table ahead of time with your Fox datasource. It can have any number of columns but must contain one memo field.
   
   For example,

   create table fox1 (col1 memo)
   						

2. In MS Query, from the File menu, select Execute SQL....
3. Click the Data Sources... button, and choose the Dbase datasource you have defined; click the Use button.
4. Create any form of Dbase table.
   
   For example:

   create table dbase1 (col1 char(30)).
   						

   Then click the Execute button to execute the SQL statement. You should receive the message:

   Microsoft Query
   Executed SQL Statement successfully

5. Click the Data Sources... button and choose the FoxPro datasource you have defined, click the Use button.
6. Try to query on the Fox table with the SQL statement:

   select * from fox1,
   						

   Click the Execute button to execute the SQL statement. You will get the message:
   Microsoft Query
   General ISAM error
   Unable to open table: fox1.