MissingMethodException error
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