Error – using memory database System.Data.Sqlite



Hello,

Been trying to make an in memory database using vb.net and the system.data.sqlite dll. however I require to copy the context from my file db first

Got this syntax -

Dim conn As SQLiteConnection = New SQLiteConnection("Data Source=:memory:;")
conn.Open()
Using cmd As DbCommand = conn.CreateCommand()
cmd.CommandText = "ATTACH '\FilDB.db3;Password=1234' AS disk"
cmd.ExecuteNonQuery()
cmd.CommandText = "CREATE TABLE tblMain as Select * from disk.tblMain;"
cmd.ExecuteNonQuery()
End Using

Getting an error stating no such table: disk.tblMain

Can you pick the error here ??

Thanks for any answers.