http://sqlite.1065341.n5.nabble.com/Newbie-issues-with-SQLite-amp-C-td65823.html
--
--
--
--Ô¿Ô--
K e V i N
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
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
