#14 Unable to load DLL 'sqlite3'

open
nobody
5
2009-12-23
2009-12-23
Anonymous
No

Hope you can help me, or point me somewhere.
I'm a VB student, intermediate, and believe the SQLite is just what I need for my project, but am unable to make it work.
Found your ADO.NET provider by reading e"SQL GUI" by Udhaya Kumar.
I downloaded your app, installed it in the BIN folder and referenced the SQLite.NET.dll as per the article.

That worked, but when I ran project got the following error:
Unable to load DLL 'sqlite3': The specified module could not be found. (Exception from HRESULT: 0x8007007E)

My code is the following:
Imports Finisar.SQLite

Public Class Form1
Private Sub btnConnect_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnConnect.Click

Dim strDirectory As String
Dim SQLiteConn As SQLiteConnection
Dim SQLiteCmd As New SQLiteCommand
'Dim SQLiteDread As New Finisar.SQLite.SQLiteDataReader

strDirectory = System.IO.Directory.GetCurrentDirectory & "MD80study"

'Create Database
SQLiteConn = New SQLiteConnection("Data Source=c:\\test-database.db;Version=3;New=True;Compress=True;")
SQLiteConn.Open()
SQLiteConn.Close()
End Sub
End Class

Thank you for your time:
Bill Medina
wgmedina@earthlink.net

Discussion