Stumped with why the record is not added to SQL db

[1712]

I have created a web application that calls a com componet from an asp page which in turns executes a stored procedure in sql server2000 to add a record.

I have tested my dll and it works fine by forcing info into the fields and executing the stored procedure.

I have tested the stored procedure through sql query analyzer.

I have looked at the values of the fields in the actual program to make sure they are correct.

Is there a way to trace everything through to the stored procedure?

 

[vishnuprasad]

I think this might help u..
What u need to do is
1.Have a breakpoint on the method(in VB Component) being called by asp.
2. Run component with compile mode...Cntrl+f5.Run this project as a standalone.(not as a project group)
3.Run the asp screen and the run mode switches to the component from where u can track the values.