I found my problem and - yes - I was totally stupid. Ahem, I had assumed that CreateDatabaseFileEx() simply opens a database if it already exists. But it makes a new database. However, I can't figure out how to open a database.
db.Host = "localhost"
db.UserName = "sa"
db.Password = "sa"
db.Port = 15532
Connected = db.Connect()
if Connected then
db.databaseName = "vsqlitetest.sqlite"
connected = db.OpenDataBaseFile
if not Connected then Connected = db.CreateDatabaseFileEx()
end if
If the database already exists then an OpenDataBaseFile doesn't open the database. In the attached screenshot you can see that isOpen = false.
How do I open a VSQLiteDatabase?