error 2147217865

Nov 03, 2007 1 Replies

I am experiencing an Error message on my second station when trying to post a transaction, usually the first or second after I open Store Operation Pos. My main data is sitting on first station. This is the error msg in Full.



Error 214721865 Cannot Drop the Table # Temp Because it does not exist in System Cat Log (Source: Microsoft OLE DB Provider for SQL Server) (SQL State:40502 Native Error 3701) Select GetDate ( ) As Current Date Time I am unable to find this error on customer source Can you post cause and RESOLUTION


---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane.



formatting link


"Gill" wrote in news:OII# snipped-for-privacy@TK2MSFTNGP05.phx.gbl:

It would seem that SQL server on Station on hasn't made any of the temp tables used to merge data in. These tables are typically made when a station starts up. It would seem you have date issues maybe the two stations are off in time/date would be my first look. Secondis how are the station configured? If your running a firewall on Station 1 then turn it off until you have this sorted. It could be as simple as a port being close.

Good Luck!

formatting link
Weigh Scale software for the Grocery Industry!

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required