Fatal Dataset Error

[Xcoder]

Hello,

Will post the code in a few hours, but in the meantime I wanted to get out this:

The scenario is - vb.net 2003 connecting to access 2003 using Jet 4.0 SP8 and MDAC 2.7 SP1.

On a particular client machine with XP SP2, while trying to fill a dataset it crashes fantastically without ANY error message. the exe just disappears from the task manager.

I use a Module to launch the MainApp form, if I try to connect within the Module BEFORE calling the:

dim MainApp as new MainApp
application.run(MainApp)

the datasets work normally, but if I do it inside the Form_Load (or anywhere inside the form) it presents the previously mentioned fatal crash.

I have updated the clients machine with the SP1 for .NET 1.1 with no luck.

Now, in a desperate attempt, I have installed VB.NET 03 in the client machine and with the dev env it works fine, but if I try to run the executable from outside, it crashes again. No error message from the exception handling inside the app, no unhandled errors from the framework or the OS, it just vanishes from the task manager.

I tried to reinstall MDAC and Jet but the installers find the previous files and won't update with the new ones.

This happened after months of daily use, I asked the usual questions:

"Have you installed anything else?"

"Have you deleted any files?"

But the customer reports nothing unusual.

Please help!

[riteshjain1982]

have you use try catch block to catch the exception? also try to look into window's event manager may be there you can get some hint.

[Xcoder]

Try Catch block is set. Will check the windows event log.

Could this be a COM related problem? If so, how can I check?

[riteshjain1982]

Could this be a COM related problem? If so, how can I check?

just a guess this should be in windows event viewer as "Error" under application log.

Also cross check if exe is running fine from other machine?

[Xcoder]

just a guess this should be in windows event viewer as "Error" under application log.

Also cross check if exe is running fine from other machine?

App working fine in other machines. Willing to check with a debugger, recommendations?