POINT OF SALE DAY END : STATISTICAL DATA NOT UPDATED SQL ERROR

Point Of Sale Day End Statistical Data Not Updated

while do day end of point of Sale it may show error message as " Could not create an instance of OLE DB provider 'SQLOLEDB' error trace [Non-interface error: CoCreate of DSO for SQLOLEDB returned 0x80004002]. " 

Type : Type of Error SQL Error.

The above error getting when create Linked server in SQL 2000.

Solution

Kindly check whether the following pre-requisite installed in your machine.

• MDAC Components.
• SQL Service Pack 3 and 3a.

If Both were already installed in your machine, just uninstall MDAC Components from your machine re install once again.