Problem with SQLite libraries

Discussion in 'Questions (Windows Mobile)' started by RB Smissaert, Dec 6, 2008.

  1. RB Smissaert

    RB Smissaert Well-Known Member Licensed User

    Trying to use AddParameter and SetParameter, but the intellisense on the command object doesn't give me those options, so it looks there is something wrong with the SQLite libraries, but not sure what as I have installed the latest versions of SQLDesktop.dll and SQLDevice.dll.
    Not sure where these files should be and also not sure about System.Data.SQLite.DLL should all these file be in the libraries folder or
    C:\Program Files\Anywhere Software\Basic4ppc Desktop\Libraries\SQLNative\Desktop\ and
    C:\Program Files\Anywhere Software\Basic4ppc Desktop\Libraries\SQLNative\Device\
    Should all 3 be added as components to the project?
    Thanks for any advice in this.

    RBS
     
  2. Erel

    Erel Administrator Staff Member Licensed User

    You also need to make sure that SQLDesktop and SQLDevice files which are located in the folder of your source code are the new ones.
     
  3. RB Smissaert

    RB Smissaert Well-Known Member Licensed User

    OK, thanks, I got this fixed now.
    How about System.Data.SQLite.DLL?
    I see that there are 2 files with same version number, but different size and
    I can see that there is a newer version out, 1.0.60.0.
    Which version should I have and where should the file(s) be?

    RBS
     
  4. Erel

    Erel Administrator Staff Member Licensed User

    One is for the desktop and one is for the device.
    When you'll compile your application the right one will be copied to the same folder as the executable.
     
  5. RB Smissaert

    RB Smissaert Well-Known Member Licensed User

    OK, how about the new 1.0.60.0?

    RBS
     
  6. Erel

    Erel Administrator Staff Member Licensed User

    It is not possible to just replace those dll files. The ones included with Basic4ppc were modified a little bit. Probably one of the future versions of the SQL library will include newer versions of these dlls.
     
  7. RB Smissaert

    RB Smissaert Well-Known Member Licensed User

    OK, thanks for clarifying.
    Where can I see on what SQLite version those dll files are based?

    RBS
     
  8. Erel

    Erel Administrator Staff Member Licensed User

    Version 1.0.40 and SQLite 3.3.12.
     
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