User1938146372 posted
I have asp.net aspx, code behind VB webpage that has a number of variables and calls a stored procedure to update them on a sqlserver database. Locally it works fine, the variables are coming from another site (payment gateway).
If I mock up that with a testpage, it runs fine on the production server and response.writing the variables as they arrive confirm the correct values. When I run it in live the database is not updated - presumably some form of sqlexception - but not sufficient
to cause any problems or crash.
Is there a way I can see the sql response code in a response write or better way to debug on a remote server?