in

System.Data.SQLite

An open source ADO.NET provider for the SQLite database engine

Is there any working version?

Last post 04-27-2010 11:33 PM by nZeus. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 04-27-2010 6:00 AM

    • nZeus
    • Not Ranked
    • Joined on 04-27-2010
    • Posts 2

    Is there any working version?

     Hello!

     I've downloaded 1.0.66.0 version, added reference to the System.Data.SQLite in my CF3.5 application and when i try to run this:

                var connection = new System.Data.SQLite.SQLiteConnection("Data Source=db.db3;Version=3;");
                connection.Open();

    i get error "Can't find PInvoke DLL 'SQLite.Interop.066.DLL'.". I've searched a lot on this error, but no solution was founded :(

    Then i tried with versions 1.0.60 and 1.0.65. And got error 

    File or assembly name 'System.Data.SQLite, Version=1.0.65.0, Culture=neutral, PublicKeyToken=1FDB50B1B62B4C84', or one of its dependencies, was not found.

    Does anybody know how to resolve any of these bugs, or, maybe, tell me where i can findworking library...

    Thanks in advance!

  • 04-27-2010 4:39 PM In reply to

    • ederas
    • Not Ranked
    • Joined on 04-27-2010
    • Posts 1

    Re: Is there any working version?

    Friend, the dlls that you needd for SQLite.NET in Compact framework are 2:

    1. SQLite.Interop.065.DLL

    2. System.Data.SQLite.dll

    Find it in C:\Program Files\SQLite.NET\bin\CompactFramework

    copy it to the same folder to executable file of the application.

    regards.

     

     

  • 04-27-2010 11:33 PM In reply to

    • nZeus
    • Not Ranked
    • Joined on 04-27-2010
    • Posts 2

    Re: Is there any working version?

    Thanks for reply!

    Adding SQLite.Interop.065.DLL to the root folder of my project with 'build action' set to 'content' and 'copy to output' set to 'copy always' and deleting application from emulator (it's important, it didn't work untill i delete it), running it again, -- this helped me!

    My problem solved :)

    Thanks again!

Page 1 of 1 (3 items)
Powered by Community Server (Commercial Edition), by Telligent Systems