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:
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"
SQLiteConn = New SQLiteConnection("Data Source=c:\\test-database.db;Version=3;New=True;Compress=True;")
Thank you for your time: