Help - Losing connection to database when tendering a sale

Hi

Had this with a customer last week who was runn> Hi,

We were seeing this issue in a couple of locations when running 1.2 with MSDE but being nowhere near the DB limit.

Curiously, when we upgraded to 2.0 and 2K5 Express we had different iterations of what are probably the same issue. We no longer have the database blowing up during transactions (okay, not blowing up but disconnecting/not found) but during lookups to the local store database. Again, this almost always happend from POS2 but SOMETIMES happens on POS1 as well.

Do let us know what version RMS and SQL you are running.

Maddening.

We've replaced cables and switches at these locations with no change... Do you guys happen to run Dell hardware? I only ask because it's one of the only correlations I can come up with between the stores that have seen this issue and those that haven't... which is to say that I'm running out of ideas, but at least we're not losing transactions now, just time.

Hi Richard-

I am having more or less the same problem that you've described at 5 separate stores. Prior to going to 2.0 our transactions were dropping frequently on POS2 (the system without the store database). The drop would occur during a transaction, usually a debit, sometimes a credit, rarely a check or cash, and close out of POS.

Mind you, we spent a lot of money on network equipment and our pings in most locations almost always show flawlessly for anybody?