Problem with Sqlite?

[JJM]

Hello,
I wrote 2 programs using Sqlite some months ago and I have compiled they with Device.exe option. I just buy a new PDA HTC Diamond and I must recompiled all my programs to adapted them to the new screen. So I compile with the option Device(Auto Scale).exe and the programs without Sqlite run well. I use Basic4ppc 6.8 and all DLL neded are in the target folder.
Could you help me?
Thanks
JJ M

 

[agraham]

So what is the problem with SQLite applications? You haven't given us any information. Do you get an error of some sort?

Without any description of what is wrong we can't help.

 

[IoSonoPiero]

Hello,
I wrote 2 programs using Sqlite some months ago and I have compiled they with Device.exe option. I just buy a new PDA HTC Diamond and I must recompiled all my programs to adapted them to the new screen. So I compile with the option Device(Auto Scale).exe and the programs without Sqlite run well. I use Basic4ppc 6.8 and all DLL neded are in the target folder.
Could you help me?
Thanks
JJ M

Maybe on the new device the DLL is already on the device.

Erel, the compiled file searchs DLL in app folder or in shared dll folders?

 

[JJM]

Sqlite

Hello,
1) When I use on my PDA a program compiled by Device(Auto scale) exe option i get an error message: "Le fichier ou l'ensemble nommé 'System.data.sqlite.device version=1.0.60.0, Culture=neutral Public key token=1FDB50B1B62B4C84' ou l'un des composants est introuvable". My PDA runs with Windows mobile 6.1 and Net.framework 2.
2)When the program using sqlite runs from Basic4ppc full version 6.80 (on the PDA or on the PC) all is OK.
3)When i compile the program using Sqlite by Device.exe option it runs fine but the window is too small.
Thanks
JJ M

 

[IoSonoPiero]

Well, when you use the SQLite library and from Basic4PPC for Windows you compile an application, the SQLDevice.dll library is embedded into exe.

Then, you have to copy:
SQLite.Interop.060.dll
System.Data.SQLite.Device.dll
into the folder where the app will be installed.

It's better to create a Cab file with contains:
the exe you generated
SQLite.Interop.060.dll
System.Data.SQLite.Device.dll

so you can always use and distribute the right files.

I hope this can be a solution for you!

 

[JJM]

Hello,
I done that and the problem is always the same!...

Thanks
JJ M

 

[Erel]

I've sent you a CAB file with a small SQL program.
Please install it and see if it runs.

 

[JJM]

Hello,
The SQLite.Interop.060.dll was not updated so it was the cause of the trouble.
Thanks

JJM

 

[IoSonoPiero]

Ok, then.

 

[Ariel_Z]

Where did you update it from?

 

[JOTHA]

Hello ghale,

do you or anyone else know where these files are to get?

Then, you have to copy:
SQLite.Interop.060.dll
System.Data.SQLite.Device.dll

I've searched a long time and all I found was a dead link: http://www.screentoaster.com/watch/...my_first_programhttp:/sqlite.phxsoftware.com/

 

[IoSonoPiero]

Hello ghale,

do you or anyone else know where these files are to get?


I've searched a long time and all I found was a dead link: http://www.screentoaster.com/watch/...my_first_programhttp:/sqlite.phxsoftware.com/

Try this instead: System.Data.SQLite

 

[agraham]

They are in "Program Files\Anywhere Software\Libraries\SQLNative\Device"

 

[JOTHA]

Hello ghale and agraham,

thank you for your fast answer.

... oops, I've searched in the internet and at least I found it on my computer!

Thanks for your tip!

 

[JOTHA]

Hello ghale,

I found this also before, but I did't know how to use it.

Try this instead: System.Data.SQLite

Now I found the DLL's on my computer ...:BangHead:

 

[Ariel_Z]

JOTHA, where did you find the broken link?

 

[JOTHA]

Hello Ariel_Z,

JOTHA, where did you find the broken link?

I found it in the Basic4ppc helpfile in the FAQ:
Basic4ppc SQL library reference

at this question:

Where do I get the latest version of SQLite interop.060?

Has someone hiked the link?