PRB: "Syntax Error in FROM Clause" Using Text ODBC Driver

• Microsoft Visual C++, 32-bit Editions, version 5.0

SYMPTOMS

When you use the AppWizard to create a CRecordset class using the ODBC Text Driver, your project will compile. However, when you try to open the recordset, you will get the following error message:

   Syntax error in FROM clause.

CAUSE

The AppWizard incorrectly parses the table as [Table].[txt], instead of as [Table#txt].

RESOLUTION

In the CTextDriverSet.cpp implementation file, find the CTextDriverSet::GetDefaultSQL() function and change the return value from

   return _T("[Table].[txt]");

   return _T("[Table#txt]");

   CString CTextDriverSet::GetDefaultSQL()
   {
      return _T("[Table].[txt]");

   }

   CString CTextDriverSet::GetDefaultSQL()
   {
      return _T("[Table#txt]");
   }

STATUS

Microsoft is researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

Steps to Reproduce Behavior

In Notepad

1. Create a text file with the following content:

         Field1,Field2
         1,abc
   

2. Save this file as Table.txt and close it.

3. Create a new User DSN based on the Microsoft Text Driver and name it TextDriverSample.

4. Clear the Use Current Directory box.

5. Click the Select Directory button and select the directory that contains Table.txt.

6. Click Options.

7. Select *.txt from the Extensions list box.

8. Click the Define Format button.

9. Select Table.txt.

10. Select the Column Name Header box.

11. From the Format combo box, select CSV Delimited.

12. Click the Guess button.

13. Save and exit the ODBC Manager.

Start Visual C++ 5.0

1. Create a new MFC application.

2. Select Single Document, then click Next.

3. Select Database View Without File Support.

4. Click the Data Source button.

5. From the ODBC combo box, select TextDriverSample, then click OK.

6. From the Database Tables list, select Table.txt.

7. Click OK, then click Finish.

8. Compile the project.