Microsoft KB Archive/148865

= PRB: Can't Access Stored Procedures in Visual FoxPro Database =

Article ID: 148865

Article Last Modified on 7/27/2000

-

APPLIES TO


 * Microsoft Open Database Connectivity Driver for Visual FoxPro 1.0

-



This article was previously published under Q148865



SYMPTOMS
From 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.



CAUSE
The 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.



STATUS
This behavior is by design.



Steps to Reproduce Behavior
 Set up a data source to the Tastrade database by following these steps:

 Start the ODBC Driver Manager. Click the Add button to add a driver. In the list of drivers, select the Microsoft Visual FoxPro Driver. In the data source dialog box, click the Visual FoxPro Database (.dbc) as the database type. Select Tastrade.dbc that is located in the Samples\Mainsamp\Data directory.</li></ol> </li> Start MSQuery 2.0.</li> On the File menu, click Execute SQL.</li> Click the Data Source button, and select the Tastrade data source.</li></ol>

The Procedures button in the Execute SQL dialog box is disabled.

Additional query words: 1.00 VFoxWin 3.00 3.00b

Keywords: KB148865

-

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

© Microsoft Corporation. All rights reserved.