Microsoft KB Archive/124322

= BUG: SQLNumResultCols on a Prepared SELECT with ORDER in Name =

Article ID: 124322

Article Last Modified on 7/27/2001

-

APPLIES TO


 * Microsoft Open Database Connectivity 2.0

-



This article was previously published under Q124322



BUG# QJET: 1813 (2.00.2317)



SYMPTOMS
When a SQLNumResultCols call is executed on a statement handle, on which you perform a SELECT query on a table and the word ORDER or GROUP appears anywhere in the table's name, SQLNumResultCols returns one of the following errors:

SQLState=37000,

szErrorMsg=[Microsoft][ODBC Microsoft Access 2.0 Driver] Syntax error in FROM clause

-or-

SQLState=S0002,

szErrorMsg=[Microsoft][ODBC Microsoft Access 2.0 Driver] Couldn't find input table or query 

For example, assume two tables exist in the database called ordering and reordering, respectively. Then the following sequence of calls will exhibit this behavior:

Case A
SQLPrepare(hstmt,"select * from ordering",SQL_NTS) SQLNumResultCols(hstmt,pccol) Returns SQL_ERROR.

SQLError(henv,hdbc,hstmt1,szSQLState,pfNativeError,SZErrorMsg) Returns

SQLState=37000 szErrorMsg=[Microsoft][ODBC Microsoft Access 2.0 Driver] Syntax error in From clause

Case B
SQLPrepare(hstmt,"select * from reordering",SQL_NTS) SQLNumResultCols(hstmt,pccol) Returns SQL_ERROR.

SQLError(henv,hdbc,hstmt1,szSQLState,pfNativeError,SZErrorMsg) Returns

SQLState=S0002 szErrorMsg=[Microsoft][ODBC Microsoft Access 2.0 Driver] Couldn't  find input table or query 're' Also, these errors are returned for table names that contain the word GROUP, like regroup, regrouping. Other examples of the table names that have the problem are border, camcorder, or grouped.



STATUS
Microsoft has confirmed this to be a problem in ODBC Access ODBC Driver version 2.00.2317. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: 2.00.2317 ODBC MFC Visual C++ MSVC Windows NT

Keywords: kbbug KB124322

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.