Put SQLite.Interop.dll in the same folder as your VB assembly (ie /debug or /release)
On Thu, Apr 18, 2013 at 9:22 AM, Gilles Ganault <gilles.gana...@free.fr> wrote: > Hello, > > I'm having a problem getting VB Express to find SQLite .Net: > > 1. I went to... > http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki > ... to download sqlite-netFx45-binary-Win32-2012-1.0.84.0.zip > > 2. Unzipped file in C:\Downloads\SQLite\.Net\1.0.84.0\ > > 3. Launched VB Express 2010 to create new Windows Form project > > 4. Project > Add Reference: Navigated to > "C:\Downloads\SQLite\.Net\1.0.84.0\" and pointed to > System.Data.SQLite.dll > > 5. Wrote SQLite test code: > > Dim SQLconnect As New SQLite.SQLiteConnection() > Dim SQLcommand As SQLiteCommand > > 'Note: Non-admin app cannot write to c:\ > SQLconnect.ConnectionString = "Data > Source=c:\users\fred\test.sqlite;" > SQLconnect.Open() > > 'SQLcommand = SQLconnect.CreateCommand > > 'SQLcommand.CommandText = "CREATE TABLE IF NOT EXISTS Item > (type)" > 'SQLcommand.ExecuteNonQuery() > > 'SQLcommand.CommandText = "INSERT INTO Item (type) VALUES > ('something')" > 'SQLcommand.ExecuteNonQuery() > > 'SQLcommand.Dispose() > SQLconnect.Close() > > 6. Launched app: "Unable to load DLL 'SQLite.Interop.dll': The > specified module could not be found. (Exception from HRESULT: > 0x8007007E)" > > What is the right way to install SQLite.Net so that applications can > find it? > > Thank you. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Markus Diersbock SwingNote Marblehead, MA C 781.929.0693 F 888.654.6068 ------------------------------------ This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential information. If you have received this e-mail in error, please contact the sender immediately and delete the material from any computer. Any review, dissemination, copying, printing or other use of this e-mail by persons or entities other than the addressee is prohibited. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
