We're running POS 1.3r using PCCHARGE. In the past month we have received 3 errors while processing either a sale or a return using a credit card. After scanning the card the register displays the following error message: ERROR
2147217871 TIMEOUT EXPIRED (SOURCE MICROSOFT OLE DB PROVIDER FOR SQL SERVER). It then goes on to say (SQL STATE HYT00 NATIVE ERROR 0) NO HELP FILE AVAILABLE.At this point the transaction exits. I've since discovered that the CUSTOMER's record has not been updated to reflect TOTALVISITS or TOTALSALES. Additionally, TENDERTOTALS, TENDERENTRY, and BATCH do not reflect the transaction. The JOURNAL is void of the register receipt.
Any thoughts about WHY and WHAT I can do to avoid this error in the future?