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
