PRB: Can't Access Stored Procedures in Visual FoxPro DatabaseLast reviewed: September 9, 1996Article ID: Q148865 |
The information in this article applies to:
SYMPTOMSFrom MSQuery version 2.0, if you connect to a Visual FoxPro database that contains stored procedures, the Procedures button of the Execute SQL dialog box is disabled. In particular, if you set up a data source to the Tastrade database, the Procedures button is disabled although the Tastrade database contains stored procedures. You were expecting this button to be enabled because the database contains stored procedures.
CAUSEThe Procedure button in the Execute SQL dialog of MSQuery calls the SQLprocedures function. This function is not supported by the Visual FoxPro ODBC driver because Visual FoxPro stored procedures cannot be executed outside of a trigger. Therefore, the Procedures button in the Execute SQL dialog box is disabled.
STATUSThis behavior is by design.
MORE INFORMATION
Steps to Reproduce Behavior
|
Additional reference words: 1.00 VFoxWin 3.00 3.00b
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |