on the confirm page, look for the following code:
<input type="hidden" name="return" id="return" value="" />
change the value to the full url of the checkout success page on your site:
<input type="hidden" name="return" id="return" value="http://www.mydomain.com/checkout_success.php" />