Hello, Our RMS 1.0 started giving error messages and crashing out when tendering a sale. This happens on any transaction where payment is involved, but does not happen when the transaction does not involve money coming in, such as a sale on account, or saving changes to a layaway.
Below are the two messages that pop up. As you can imagine, resolving this is critical for our the functioning of our store. Any help is appreciated, since hiring a tech is not an option right now.
-Ben
503-233-2577--- 1st error:
Error #-2147467259 Connection failure (Source: Microsoft OLE DB provider for SQL Server) (SQL State: 08S01) (NativeError: 0) No Help file available SELECT GETDATE() AS CurrentDateTime
--- 2nd error:
Error #-2147467259 (Source: Microsoft OLE DB provider for SQL Server) (SQL State: HY000) (NativeError: 3624) No Help file available SET NOCOUNT ON INSERT INTO TenderEntry ( StoreID, BatchNumber, TransactionNumber, PaymentID, OrderHistoryID, DropPayoutID, TenderID, Description, Amount, AccountHolder, CreditCardNumber, CreditCardExpiration, CreditCardApprovalCode, RoundingError, AmountForeign, SerialNumber, TransitNumber, VisaNetAuthorizationID) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) SELECT @@IDENTITY AS TenderEntryID Update TenderTotals SET TenderTotals.[Count] = TenderTotals.[Count] + ?, TenderTotals.Shift = TenderTotals.Shift + ?, TenderTotals.ShiftForeign = TenderTotals.ShiftForeign + ?, TenderTotals.ShiftRoundingError = TenderTotals.ShiftRoundingError + ?, WHERE TenderTotals.BatchNumber = ? AND TenderTotals.TenderID = ?