PInvoke In SQLite

Hi

I wonder if somebody can help me. As soon as my program wants to open a Database, I get the error message "Can't find PInvoke DLL SQLite.Interop.060.DLL".

I never had this error before and I have not changed anything in the program:BangHead:

Thanks
Michael

You should have a file named SQLite.Interop.060.dll in your program path.
This file should be copied automatically to the target folder when you compile your program (with B4P v6.8).

You can also find it under: c:\Program Files\Anywhere Software\Basic4ppc Desktop\Libraries\SQLNative\Device

Hi Erel

That file has been copied to my handheld. This is what I cannot understand, it used to work.

Can I sent you a copy of the program to see what I am doing wrong?

Thanks
Michael

Are you trying to run it in the device IDE? If so make sure there is a copy of the Interop library in the Basic4ppc Program folder on the device. When running in the IDE the device thinks that is where the program started from and looks there for native libraries.

Hi Agraham:sign0188:

Thanks for your help, but it still does not work:BangHead::BangHead:

I have copied the Interop dll to the Basic4ppc folder, but no success. What I cannot understand is that the stuff used to work. The only difference is the CAD module that has been rewritten and is much bigger than the old one. The program is about 3.2 Mb big. Could that maybe be the problem?

Something that is also funny, is that on most of the other PDA (Recon & Workabout) it works fine. I have a Recon and it does not work:BangHead: Other surveyors that have 2 Recons will have it working on one PDA but not on the other.

Please advise:sign0085:

Regards
Michael

You haven't said so but is it optimised compiled? If it is and if you are running it from a folder on a storage card can you try running it from internal storage.

Hi Agraham

It has been optimized compilied and I am running it from the internal memory. The program is not stored on a SD card.

Regards
Michael

If it works on some systems and not on others you may be running out of Virtual Memory space in which dlls are loaded.

The Windows Mobile RSS (Reed and Steve Stuff) Feed : Slaying the Virtual Memory Monster

The Windows Mobile RSS (Reed and Steve Stuff) Feed : Slaying the Virtual Memory Monster - Part II

You could try a soft reset and then, before running anything else, see if your program now runs.

Hi Agraham

Thanks for your help:sign0188:

I have found the problem....it is the memory that is running out:BangHead:

What I have done now is to remove the "Stockpile", "Mapping" and "Office" modules and have them as seperate ".exe" files. I am using the "Shell" command to run these programs.

Now it works again!

Regards
Michael