Article ID: 170823
Article Last Modified on 11/21/2006
APPLIES TO
- Microsoft Foundation Class Library 4.2, when used with:
- Microsoft Visual C++ 2.0 Professional Edition
- Microsoft Visual C++ 2.1
- Microsoft Visual C++ 2.2
- Microsoft Visual C++ 4.0 Standard Edition
- Microsoft Visual C++ 4.0 Standard Edition
- Microsoft Visual C++ 4.1 Subscription
- Microsoft Visual C++ 4.2 Professional Edition
- Microsoft Visual C++ 4.2 Enterprise Edition
- Microsoft Visual C++ 4.2 Professional Edition
- Microsoft Visual C++ 1.52 Professional Edition
This article was previously published under Q170823
SYMPTOMS
When you use the "Call" syntax to invoke a stored procedure when opening a recordset, an exception might be thrown. Depending upon the version of Visual C++, whether or not you have DB Tracing enabled and the DBMS in use, you might see one of the following errors:
DBMS specific error information: DBMS Error String Native Code ------------------------------------------------------------------ SQL Server: Incorrect syntax near the keyword 'EXEC'. 156 Access: Syntax error in FROM clause. -3506 (and other desktop drivers)
NOTE: If you are using Visual C++ 1.5X and connecting to a 16-bit SQL Server datasource, an exception may not be thrown but the desired result set is not returned.
CAUSE
While this line of code may appear to be a perfectly valid way to invoke a stored procedure, there is a small error:
The space between the "{" and the "C" cause MFC to misinterpret the Call statement as the name of a table. MFC makes a case insensitive comparison between any SQL provided in the Open() call and the literal constant szCall, which is defined as _T("{call "). If the comparison fails, the provided SQL is incorrectly incorporated into a SELECT statement that is executed instead of the stored procedure call.
RESOLUTION
Make sure that there are no extra spaces between the first curly brace and the "Call" key word.
STATUS
This behavior is by design.
Keywords: kbdatabase kbprb KB170823