#11 Can we get updated ARM/x86 DLL's?

open
nobody
None
5
2006-02-13
2006-02-13
AzzaAzza69
No

The created dll's are Feb 2005, but features like the
'AUTOINCREMENT' keyword or CURRENT_TIMESTAMP (which we
added in Jan 2005) don't work!

Can you re-compile the dll's?
[or list instructions on how to re-compile them (with
Visual Studio 2003) and I'll post them to SF]

Thanks,
Azza

Discussion

  • Stevie Oh

    Stevie Oh - 2006-05-17

    Logged In: YES
    user_id=353387

    Azza, I discovered this problem when I tried to use SQLite.NET as well.

    The problem is not that the files need to recompiled, but that an ancient copy of SQLite's codebase is being used (from 2000). I stepped through tons of code, only to eventually discover this.

    There is an easy solution, however: go to http://www.sqlite.org/download.html and download the DLLs. At this time, the direct links are:

    http://www.sqlite.org/sqlitedll-2_8_17.zip => SQLite2 v2.8.17
    http://www.sqlite.org/sqlitedll-3_3_5.zip => SQLite3 v3.3.5

    Just take the DLLs that are in those archives and copy them either into your application's directory, or into your %SYSTEMROOT%\SYSTEM32 (under NT/2000, WINNT\SYSTEM32, elsewhere WINDOWS\SYSTEM32) directory. The API hasn't changed, so the .NET assembly will work with the new sqlite libraries without needing to be recompiled.

     
  • Nobody/Anonymous

    Logged In: NO

    yoav should download the free Microsoft Embedded Visual C++
    4.0, then go here: http://sqlite-wince.sourceforge.net/,
    download the source, and use the instructions to build the
    dll. It should work.

    -Yoav.

     
  • AzzaAzza69

    AzzaAzza69 - 2006-07-03

    Logged In: YES
    user_id=446405

    steve-o,

    Your 'replace the dll' approach didn't work for me/.NET-CF.
    I replaced the SQLite3.dll and it gives me a 'MissingMethod
    exception' for the Open method.

    There are 4 dll's needed on the device:
    SQLite.dll <229k>
    SQLite3.dll <241k>
    SQLite.NET.dll <64k>
    SQLite3_wrapper.dll <4k>

    As for the option to re-compile 'sqlite-wince' - how would
    this work for .NET-CF?

     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks