Problem with Sqlite?

Discussion in 'Questions (Windows Mobile)' started by JJM, Aug 5, 2009.

  1. JJM

    JJM Active Member Licensed User

    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
     
  2. agraham

    agraham Expert Licensed User

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

    Without any description of what is wrong we can't help. :(
     
  3. ghale

    ghale Active Member Licensed User

    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?
     
  4. JJM

    JJM Active Member Licensed User

    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
     
  5. ghale

    ghale Active Member Licensed User

    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!
     
  6. JJM

    JJM Active Member Licensed User

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

    Thanks
    JJ M
     
  7. Erel

    Erel Administrator Staff Member Licensed User

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

    JJM Active Member Licensed User

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

    JJM
     
  9. ghale

    ghale Active Member Licensed User

    Ok, then.
     
  10. Ariel_Z

    Ariel_Z Active Member Licensed User

    Where did you update it from?
     
  11. JOTHA

    JOTHA Well-Known Member Licensed User

  12. ghale

    ghale Active Member Licensed User

  13. agraham

    agraham Expert Licensed User

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

    JOTHA Well-Known Member Licensed User

    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!
     
  15. JOTHA

    JOTHA Well-Known Member Licensed User

    Hello ghale,

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

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

    Ariel_Z Active Member Licensed User

    JOTHA, where did you find the broken link?
     
  17. JOTHA

    JOTHA Well-Known Member Licensed User

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

    at this question:
    Has someone hiked the link?
     
    Last edited: Oct 8, 2009
Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice