VBA error in sandbox

dalefye1 — Sun, 15 Mar 2020 18:02:52 GMT

This is really bizarre. I have two Access applications running a test app and a client app.

In the test app, I have used the following to post a request and get a response, and it works fine:

Test App
Post_URL: https://test.authorize.net/gateway/transact.dll
Post string:x_login=mylogin&x_tran_key=mykey&x_delim_data=TRUE&

x_delim_char=|&x_relay_response=FALSE&x_type=AUTH_CAPTURE&

x_method=CC&x_card_num=4111111111111111&x_exp_date=0320&

x_amount=608.78&x_description=My%20Client%20Name%20&

x_invoice_num=79012

The code that actually posts this looks like:

Dim objRequest As New MSXML2.XMLHTTP
objRequest.Open "POST", TempVars!Post_Url, False
objRequest.send post_string
post_response = objRequest.responseText

And the response looks like:

1|1|1|This transaction has been approved.|0L2DGF|Y|60139380095|79012|My Client Name|608.76|CC|auth_capture|||||||||||||||||||||||||||P|2|||||||||||XXXX1111|Visa|||||||KUSP422B9Z14N6LIB9XSZ1F||||||||||

But when I run basically this with basically an identical post string in the client application:

My Client Name
URL: https://test.authorize.net/gateway/transact.dll
Post: x_login=mylogin&x_tran_key=mykey&x_delim_data=TRUE&

x_delim_char=|&x_relay_response=FALSE&x_type=AUTH_CAPTURE&

x_method=CC&x_card_num=4111111111111111&x_exp_date=0320&

x_amount=608.78&x_description=My%20Client%20Name%20&

x_invoice_num=04168

I get an error message: -2147467259 Unspecified error

and the line of code that is highlighted, generating the error is:

objRequest.send post_string

The Invoice_Num value in both of these applications is based on:

x_invoice_num=" & URLEncode(Right(Timer * 100, 5))

to avoid duplicates

The code in the test application works fine, every time returning approved and unapproved messages depending on the values passed, but the client application is returning this error, every time it is run.

I am beyond frustrated!

topic VBA error in sandbox in Integration and Testing

VBA error in sandbox