Remember that System.Data.SQLite.dll needs to be able to find the SQLite.Interop.dll. There's a post-build step that attempts to copy the Interop DLL to the appropriate debug directory. You may still need to copy into your debug directory for your test purposes.
On Wed, Apr 20, 2011 at 3:04 PM, Rich Rattanni <ratta...@gmail.com> wrote: > Shane: > > I downloaded http://system.data.sqlite.org/sqlite-dotnetsrc-1006900.zip > and changed SQLite.NET.Settings.targets as per your recommendation. > It did not appear to solve my problem since my application threw an > exception stating that Sqlite.Interop was missing. To be complete I > tried 3 permutations of the two options UseInteropDll and > UseSqliteStandard ( I did not try false, false). > > All resulting System.Data.SQLite.DLLs threw exceptions due to a > missing InterOp DLL. I pulled down a copy of System.Data.SQLite > 1.0.66.0 and built the Managed Only version, and it appeared to work. > > I will mess around some more with the project to see if I can build > the managed only version. I was hoping to get my hands on the latest > so I was not fighting issues that may have been fixed by a release. > Thank you again for trying to help, rest assured it was appreciated. > > -- > Rich > > On Tue, Apr 19, 2011 at 5:36 PM, Rich Rattanni <ratta...@gmail.com> wrote: > > Daniel: > > > > I have not tried Csharp-sqlite, it looks interesting but I do not know > > if that is right for me at this moment. > > > > Shane: > > > > I will try what you recommend tomorrow, thank you. > > > > -- > > Rich > > > > On Tue, Apr 19, 2011 at 4:47 PM, Shane Harrelson > > <shane.harrel...@gmail.com> wrote: > >> The target build settings can be controlled from > SQLite.NET.Settings.targets > >> - in particular, you should probably look at UseInteropDll and > >> UseSqliteStandard. > >> To override the USE_INTEROP_DLL setting, try copying > >> SQLite.NET.Settings.targets to SQLite.NET.Settings.targets.user and make > the > >> settings changes there. > >> This should work with VS2008 and VS2010. > >> > >> HTH. > >> -Shane > >> > >> > >> On Tue, Apr 19, 2011 at 3:09 PM, Rich Rattanni <ratta...@gmail.com> > wrote: > >> > >>> I was wondering if anyone has had any luck building the Managed-Only > >>> System.Data.SQLite .NET adapter for SQLite from the source provided at > >>> system.data.sqlite.org? I downloaded the pre-built binaries but they > >>> appear to rely on the InterOp assembly. My current project is running > >>> under Linux 2.6 on an ARM processor, and uses managed-only copy of the > >>> System.Data.SQLite adapter + SQLite 3.5.0 + mono to run my .NET app. > >>> I am looking to do some bug tracing / upgrading so I would like to > >>> build my own copy from source. > >>> > >>> -- > >>> Rich > >>> _______________________________________________ > >>> sqlite-users mailing list > >>> sqlite-users@sqlite.org > >>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > >>> > >> _______________________________________________ > >> sqlite-users mailing list > >> sqlite-users@sqlite.org > >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > >> > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
