You can execute procedures in the data source by using the ExecuteProcedure method.
Specify procedures and fields to be processed in the DBAccess property page by following the steps outlined below:
Set TargetType
Select "Procedure".
Select the Data Source to connect to.
Select the "Connect" button and set the requested information such as data source name and database.
Select the target procedure.
Select the "Target" button and select the procedure name to be processed.
Select Fields
Select the "Fields" button and the result field name to be processed (in the case of the procedure to create the result set). The parameter field and return value field are selected automatically. Fields shown with an arrow pointing right are input parameters, fields shown with an arrow pointing left are output parameters and fields shown with an arrow pointing right and left are input/output parameters.
Set other information
Select the "Others" button and set the following information:
Setting cursor type
Select the appropriate setting in the "Cursor type" group box. The choices other than FORWARD_ONLY also enable reading forward. Some options may not operate correctly because of the manner in which the ODBC driver functions.
Selecting commit mode
Select the appropriate setting in the "Commit mode" group box.
Apply your changes
Select the "Apply" button to save the information you have set.
Close the Property page
Select the "OK" button and close the property page.
