Thanks for replying.
Regarding the connection error there is only one connection being used on the page. What's interesting is the details behavior was working fine with the same connection. Just modified trigger on the behavior then error appeared. User rights are good (setup with update, select and insert privileges for the database).
I am using PayPal Standard and do have IPN in place. How can I prevent duplicate detail order records from being inserted each time the user chooses to modify billing info from the confirm page then returns to confirm page?