What is the procedure to call a Stored Procedure of Back End in ADO (ActiveX Data Object) and RDO (Remote Data Objects)?
- 1 Answers
- 1142 Views
- CGI, I also Faced
- E-Mail Answers
Answer Posted / Ansa Christopher Raj
To call a stored procedure using ADO, you can use the Command object with the command type set to adCmdStoredProc. Here's an example:
1. Create a new Connection object.
2. Open the connection.
3. Create a new Command object based on the open connection.
4. Set the command text to the stored procedure name, and set the command type to adCmdStoredProc.
5. Optionally, add parameters using the Parameters collection of the Command object.
6. Execute the command and process the results."
For RDO, the process is similar:
1. Create a new Connection object.
2. Open the connection.
3. Create a new Recordset object based on the open connection.
4. Set the recordsource property to the stored procedure name.
5. Optionally, add parameters using the Parameters collection of the Recordset object.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
