close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 or 2018 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Live paypal to paypal sandbox

Thread began 6/27/2010 2:16 pm by rafael.ordaz410005 | Last modified 7/19/2010 3:07 pm by Jason Byrnes | 2133 views | 13 replies |

rafael.ordaz410005

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

Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

rafael.ordaz410005

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

Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

rafael.ordaz410005

File attached

Attached Files
confirmasp.zip
Sign in to reply to this post

Jason ByrnesWebAssist

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

Sign in to reply to this post

rafael.ordaz410005

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

Sign in to reply to this post

Jason ByrnesWebAssist

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

Sign in to reply to this post

rafael.ordaz410005

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

How can I now that?

Sign in to reply to this post

Jason ByrnesWebAssist

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:

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




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

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...