MissingMethodException error - Please help

Archived from groups: microsoft.public.pocketpc (More info?)

I am having a problem with my PreSale and Delivery
program. I am getting a MissingMethodException Error
(Randomly) and have not been able to fix it. I get 3-5
call per day concerning this.

Here is a brief description:

The program is on Symbol PDT8100's and Dell Axim's in 5
locations. The user picks up a zip file from the AS/400
IFS(integrated File System) and unzips it. They pick this
file up via cradle, infrared(Clarinet), Nextel(Socket cf
adapter), t-mobile, Socket 56K modem, or Pegasus II
infrared modem. They take orders through the day (they
can transmit back orders as they take them if needed), and
then run an end of day to reset for the next day. If they
are printing invoices, the also pick up a zip file using
the same methods described above (Begin of day), and print
their invoices on site via Bluetooth(Syscan ZFP3), cradle
(symbols only-Symbol RT1000 printer), or infrared. I have
2 programs that do this, CCClark_RSS and CCClark_Reset.
My problem is with CCClark_Reset.

When CCClark_RSS gets ready to exit, it checks to see if
it needs to run an "End of Day". If so, it PInvokes
CCClark_Reset, and then ends. CCClark_Reset runs without
forms (In the background) and creates new data for the
next day's work. In CCClark_Reset, I used one of the
methods Larry Roof described in his book to load my
database from the unzipped text files that have been
transmitted. I use a general routine called LoadFile to
do this, loading every file with this routine. Randomly,
I get a MissingMethodException error as I write our the
record to the file. I am logging statements to a logfile
to try to catch what is causing the error, and I know that
it occurs on the line where I
run "insertRow.ExecuteNonQuery()". In my log file I am
writing out the commandtext for the insertrow object, and
I can take that same line, copy it out of my logfile, and
run it using Query analyzer with no errors.

To make matters worse, I can delete my database (My zip
file still exists at this time on the device) and rerun
the program using the same device, program, and zip file.
It will run with no errors most of the time. If it does
not, I repeat the process again and it will run.

Consequentially, I am at a total loss as to how to fix
this problem. That is why I need help. I have this
program out in some locations, but have refrained from
sending it everywhere until I have a fix for this issue.

Thanks....

Chris Durbin
Programmer/Analyst
300 Oakland-Flatrock Road
Oakland, KY 42159
270-563-4735 ex 113