473,725 Members | 2,232 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Authorize.net Access 2003 & Access 2002 Problem

Hello,
I have code within my DB application to process credit cards through
authorize.net. Ive been using the same code for several years without a
problem.
I have an order entry computer and after reinstalling Win XP, we used
Office/Access 2003.
When we try to process CC's we get a debug screen and Access itself
crashes.
However, the code still runs fine on Access/Office XP. The debug screen
says: Method 'doSSLPost' of object 'ISSLPost' Failed

Here is the area that seems to be causing the problem:
'Create a new Auth object
Set AuthNetPost = New AuthNetSSLConne ct.SSLPost

Here is more of the code from the beginning:
Private Sub btnUpload_Click ()

Dim AuthNetPost As AuthNetSSLConne ct.SSLPost
Dim Connection As ADODB.Connectio n
Dim RecordSet As ADODB.RecordSet
Dim UpdateRS As ADODB.RecordSet
Dim PostString As Variant
Dim AuthCode As Variant
Dim ResponseReasonT ext As Variant
Dim ApprovalCode As Variant
Dim ccID As Long
Dim sQuery As String
Dim BatchDate As Date
Dim mcrDeclineUpdat e As String
Dim MacroUpdate As String
Dim Count As Integer
Dim mcrCCCustRefUpd ate As String

DoCmd.Hourglass True
'Update CC Table with Cust Ref Numbers
DoCmd.RunMacro "mcrCCCustRefUp date"

'Execute the stored procedure
Set RecordSet = New ADODB.RecordSet
RecordSet.Open "EXEC qryCCUpload", CurrentProject. Connection

'Create a new Auth object
Set AuthNetPost = New AuthNetSSLConne ct.SSLPost

'loop through the record set
Do Until RecordSet.EOF

'Build query string
PostString = "x_Login=" & RecordSet!coCCL ogin & ", "
PostString = PostString & "x_Password =" &
RecordSet!coCCP assword & ", "
PostString = PostString & "x_Invoice_Num= " & RecordSet!ccID &
", "
PostString = PostString & "x_Description= " &
RecordSet!Descr iption & ", "
PostString = PostString & "x_Amount=" &
Format(RecordSe t!Amount, "0.00") & ", "
PostString = PostString & "x_Method=" & RecordSet!Payme ntMethod
& ", "
PostString = PostString & "x_Type=" & RecordSet!Trans Type & ",
"
PostString = PostString & "x_Card_Num =" & RecordSet!ccNum ber &
", "
PostString = PostString & "x_Exp_Date =" & RecordSet!ccExp Date &
", "
PostString = PostString & "x_Cust_Id= " &
RecordSet!custR eferenceNo & ", "
PostString = PostString & "x_First_Na me=" & RecordSet!custN ame
& ", "
PostString = PostString & "x_Last_Nam e=" & RecordSet!LastN ame &
", "
PostString = PostString & "x_Company= " & RecordSet!Compa ny & ",
"
PostString = PostString & "x_Address= " & RecordSet!Addre ss & ",
"
PostString = PostString & "x_City=" & RecordSet!CCCit y & ", "
PostString = PostString & "x_State=" & RecordSet!CCSta te & ", "
PostString = PostString & "x_Zip=" & RecordSet!CCZip & ", "
PostString = PostString & "x_Country= " & RecordSet!Count ry & ",
"
PostString = PostString & "x_Email=" & RecordSet!Email & ", "
PostString = PostString & "x_Phone=" & RecordSet!Phone & ", "
PostString = PostString & "x_Fax=" & RecordSet!Fax
'PostString = PostString & ", x_Test_Request= TRUE"

DoCmd.Hourglass True

'Post the data
AuthNetPost.doS SLPost PostString

'Set return values from authnet
ApprovalCode = AuthNetPost.Get Field(1)
ResponseReasonT ext = AuthNetPost.Get Field(4)
AuthCode = AuthNetPost.Get Field(5)
ccID = RecordSet!ccID
BatchDate = Date

'Build update SQL
sQuery = "UPDATE tblCCInfo "
sQuery = sQuery & "SET ccBatch1 = Yes, "
sQuery = sQuery & "ccApprovalCode 1 = " & ApprovalCode & ", "
sQuery = sQuery & "ccResponseReas on1 = '" & ResponseReasonT ext
& "', "
'************** *************** *************** *************** *************** **********
If (ApprovalCode = 1) Then
sQuery = sQuery & "ccAuthorizatio nCode1 = '" & AuthCode &
"', "
Else
sQuery = sQuery & "ccAuthorizatio nCode1 = 0, "
End If
'************** *************** *************** *************** *************** **********
sQuery = sQuery & "ccBatchDat e = ' " & BatchDate & "'"
sQuery = sQuery & " WHERE ccID = " & ccID
'Execute the update statement
Set UpdateRS = New RecordSet
UpdateRS.Open sQuery, CurrentProject. Connection
Set UpdateRS = Nothing

RecordSet.MoveN ext
Loop

RecordSet.Close

'Destroy the AuthNetPost object and recordset
Set AuthNetPost = Nothing
Set RecordSet = Nothing
'************** ********End Processing Original Orders ***********
Is there anything obvious that allow this to run in Access Xp and not
in Access 2003?
Thanks,
Jay

Jul 27 '06 #1
0 2335

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

14
4188
by: wolftor | last post by:
1) Is there a free runtime version of Access available that is more recent than the one for Access 2000? 2) If I create an application (MDE) in A2K, will it run on all later versions of Access? 3) If I create a CD using A2K Developer that includes the runtime version of Access 2K and an installation package, and if someone tries to install the application from the CD, what happens if someone already has Access 2000 or a later version...
0
2412
by: Sabine Oebbecke | last post by:
Hi Experts! I have several forms and reports where controls get their values with 'Forms!MainForm!Control' or 'Forms!MainForm!Subform!Control' resp 'Forms!MainForm!Subform.Form!Control' which works without any problem in Acc97, 2000 and 2002, but now in Access 2003 there seem to be a problem with this. A user is working with my app, and he uses an Access 2002 MDE in an Access 2003 environment.
1
5745
by: Wayne Aprato | last post by:
I have a client who is running several Access 97 databases that I have written for them. They are about to upgrade to Access 2003. Is the default file format of Access 2003 still Access 2000 the same as it was in Access 2002? I am running Access 2002 at the moment. Is there any reason for testing purposes etc, for me to purchase Access 2003 if I am going to recompile the Access 97 mdb files into Access 2000 format mde files which...
7
3463
by: Wayne Aprato | last post by:
I have several Access 2003 mde databases. When I try to open them in Access 2002 I get the following error: "The Visual Basic for Applications project in the database is corrupt." Interestingly I can open the mdb files of the same 2003 databases in Access 2002 without problems. To my understanding the file formats of 2002 and 2003 are the same and this problem shouldn't exist. And why is it only the mde files that are giving the...
6
4750
by: Peter Frost | last post by:
Please help I don't know if this is possible but what I would really like to do is to use On Error Goto to capture the code that is being executed when an error occurs. Any help would be much appreciated. Thanks in advance
47
4537
by: ship | last post by:
Hi We need some advice: We are thinking of upgrading our Access database from Access 2000 to Access 2004. How stable is MS Office 2003? (particularly Access 2003). We are just a small company and this is a big decision for us(!) It's not just the money it's committing to an new version of Access!
4
2541
by: RM | last post by:
Had VS .Net 2002 installed on W2k Server SP3 and supported a number of web sites. Installed VS .Net 2003 on Friday and now all web sites using .Net & MS ACCESS get this strange error upon open. ASP=/TestDotNet/AdoNet.aspx System.Data.OleDb.OleDbException: Unspecified error at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) at System.Data.OleDb.OleDbConnection.InitializeProvider() at System.Data.OleDb.OleDbConnection.Open()...
3
2345
by: banba_ca | last post by:
When I create a new db from the main Access window or thru Vb (set newdb = ...) I always end up with Access 2000 file format. I would like to get 2002 - 2003 file format. The reason is that when I try to link from a 2002 - 2003 db to a 2000 db, the Jet engine complains that it can't find the table in the target (2000) database. And no, I can't convert on the fly. Any suggestoins would be appreciated. ....Banba
0
2756
by: Sebastian | last post by:
Hello I develop my applications in Access 2002. My development system is running Windows XP SP2 and I have Microsoft Office XP Developer. Microsoft Office XP is at SP3. I used Inno Setup (great product) to install my applications. When the Access Runtime was needed on the system I simply ran 'accessrt.msi' from Microsoft Office Developer discs. When another version of Access (other than Access 2002) was on the system then I simply...
0
8888
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8752
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9401
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8097
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6702
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6011
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
3221
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2635
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2157
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.