I am trying to run a stored procedure resides in Informix Database.

I am using ASP code to run the stored procedure (Inserting one record in the database table)
Not getting any error while running the ASP page code given below

-----------------------------------------------------------------
''''''Paramerters Input
pRsrvtnRef = 1
pRsrvtnCode = "E"

Set connIS = Server.CreateObject("ADODB.Connection")
objConnIS.ConnectionString = "Dsn=ICacheDB;Driver={INFORMIX 3.2 BIT};"
connIS.Open

Set cmdSC = Server.CreateObject("ADODB.Command")
cmdSC.ActiveConnection = objConnInformixServer
cmdSC.CommandText = "p_AddRsrvtnV1"
cmdSC.CommandType = adCmdStoredProc


cmdSC.Parameters.Append cmdSC.CreateParameter("@pRsrvtnRef", adInteger, adParamInput, , pRsrvtnRef)

cmdSC.Parameters.Append cmdSC.CreateParameter("@pRsrvtnCode", adChar, adParamInput, 1, pRsrvtnCode)

cmdSC.Execute
connIS.Close

Response.Write("Executed")
Response.End
------------------------------------------------------
Page is runnning fine but not able to insert any record into the table used inside the procedure.

Same input data (2 input parameters) is running the stored procedure manually.

Can any body help me how to trace if the stored procedure is running or not ??? If yes, then where is the error.

Note: Stored procedure i am running is standard and full proof.



KG

__________________
KG