checkout_success.asp suddenly not working
I'm using eCart 4 and ASP. I've had the checkout_sucess page working fine for a long time now, but suddenly it seems to have failed.
The success page uses Universal Email to send a receipt, shows the order ID and customer email in the confirmation text and updates the Orders table entry to "Paypal Success".
The email is being sent fine, but I'm getting a database error on the page itself when it attempts to show the order ID. It looks like the recordset isn't being found from the Orders table on the page itself, but it is being found for the Universal Email part as all order and client details are being shown perfectly in the received email.
Can you shed any light on this for me please? I can post any relevant files here or via a ticket as you wish.
Many thanks, Simon.