You receive a "Syntax error in FROM clause" error message when you use the AppWizard to create a CRecordset class by using the ODBC Text Driver in Visual C++ (177947)


The information in this article applies to:

  • Microsoft Data Access Components 2.5, when used with:
    • Microsoft Visual C++, 32-bit Enterprise Edition 6.0
    • Microsoft Visual C++, 32-bit Enterprise Edition 5.0
    • Microsoft Visual C++, 32-bit Professional Edition 5.0
    • Microsoft Visual C++, 32-bit Professional Edition 6.0
    • Microsoft Visual C++, 32-bit Learning Edition 6.0
This article was previously published under Q177947

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]");
to the following: 
   return _T("[Table#txt]");
Here is the function before the changes: 
   CString CTextDriverSet::GetDefaultSQL()
   {
      return _T("[Table].[txt]");

   }
Here is the function after the changes: 
   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 or Visual C++ 6.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.
Modification Type:MajorLast Reviewed:6/2/2005
Keywords:kberrmsg kbtshoot kbDatabase kbMDACNoSweep kbprb KB177947 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.