I am having trouble with a table in our sales and order entry system (MS Great Plains...using SQL server 2000) causing lock ups. The table in question is the items table (SOP10200). This table seems to be uneditable by Great Plains for periods up to 45 minutes. This issue began about a year ago and has progressively gotten worse. One of the changes we have made over the last year is how we run reports. Previously we ran reports through Crystal Reports 11 using the ODBC (RDO) driver. Now we have slowly made the switch to using the OLE DB (ADO) driver. This driver seems to run the reports about 2-3 times faster than the ODBC driver. But, the frequency of lockups for the sales and order entry (Great Plains) has increased. Is it possible that running reports using the OLE DB driver affects the tables differently than running them with the ODBC driver? Could the OLE DB driver be putting a lock on the items table?
Start Free Trial
