Live paypal to paypal sandbox

I recently setup the ecart 4.0 using paypal payment pro API credentials, later I learned they have differents API crendentials for the sand box.

How Can I swith to PAYPAL SANDBOX? I would like to perform test using the sandbox.

Thanks

PayPal Payments Pro Uses 4 server behaviors over 3 pages:

checkout.php:
Authentication For PayPal Express Checkout

confirm.php:
eCart Local Checkout

pp_confirm.php:
Get payer Profile From PayPal Express Checkout
Process Transaction with PayPal Express Checkout

In the server behaviors panel, double click each of these server behaviors to change the API Credentials used and toggle the Use sandbox option.

After updated the API credentials in:

checkout.asp
confirm.asp
pp_confirm.asp
pp_cancel.asp
pp_checkout_success.asp

=========================

I'm getting this error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

/confirm.asp, line 67

this error is happening on the store order summary or details behaviors.

I will need to see your confirm.asp page to examine the code.

File attached

the error is occurring on the following line:
WA_editCmd.CommandText = "insert into " + WA_table + " (" + insertParamsObj.WA_tableValues + ") values (" + insertParamsObj.WA_dbValues + ")";


see the following page for details on the cause and solution to this problem:
how-do-i-solve-operation-must-use-an-updateable-query-errors.html

Jason,

The database permissions on asp seems to be solved, I'm still waiting for their confirmation.

I'm stuck now on "checkout_failure.asp" with this message...

==========================
Transaction Not Completed

We're sorry

Your transaction could not be completed.
==========================

thanks

see the "Debugging eCart transaction failed issues" tutorial on the eCart support page:
ecart/

Paypal technical support is asking to which url is being passed the transaction. (Paypal's url address)

How can I now that?

if you have the use sandbox option selected, it will post to:
2.0/

otherwise the transaction will post to:
2.0/


if you add:

<pre>
<?php var_dump($_SESSION); ?>
</pre>

to the failure page, the URL being used should be somewhere in the session contents.