by Hi there. Can anyone show me a way to execute a stored procedure with input
parameters and retrieving the output parameter(s)? The following is the
code I have in my Interdev.
/**** begin
*****************************************************************/
set cmd = server.CreateObject("ADODB.Command")
cmd.ActiveConnection=dataconn
cmd.commandtype=&H0004
cmd.commandtext="sp_check_room_availability"
set parm=cmd.createparameter("ProductID", 3, &H0001,,1)
cmd.parameters.append parm
set parm=cmd.createparameter("DateFrom", 7, &H0001,, "1/1/1999")
cmd.parameters.append parm
set parm=cmd.createparameter("DateTo", 7, &H0001,, "1/5/1999")
cmd.parameters.append parm
set parm=cmd.createparameter("RoomStatus", 200, &H0002, 20)
cmd.parameters.append parm
set rs = server.CreateObject("ADODB.Recordset")
rs.Open cmd
while not rs is nothing
set rs = rs.NextRecordset()
wend
response.write(cmd.parameters("RoomStatus").value)
/***** end
******************************************************************/
When the application executes this, I get the following error.
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
[Microsoft][ODBC SQL Server Driver]Optional feature not implemented
Can anyone help me? What is the problem with my code?
Thank you.
Antonio Yu