Failed to open database

[awsl1414]

This is the problem I had, I've seen similar issues and that didn't solve my problem.
SQLite is installed
system:archlinux
visual-studio-code version: 1.77.1-1
SQLite version:0.14.1

[gelie]

I have the exact sane problem on Manjaro (archlinux based), the same versions of vscode and SQLite!!

[mikael-bergstrom-ntisthlm]

Getting the same error (Windows 11), but only if SQLite is installed and on the path / detected. I installed SQLite through Chocolatey, and when I uninstalled it the extension worked again.

It seems the built-in SQLite client works, but the regular one does not.

[HeinzRuetschi]

Have the same problem when trying to open a database which works within sqlite3.

Can work within the VS Code editor and use >sqlite:run query to get an sqlite output.

When trying to open the test.db file with right click selecting open Database, the error shows as shown below:

[2:44:41 PM][vscode-sqlite][ERROR] Failed to open database 'c:\Users\HR\Documents\sqlite\test.db': Parse error near line 4: no such column: table
aster WHERE (type="table" OR type="view")
error here ---^

Windows 10 and latest Version of VS Code
Version: 1.83.1 (system setup)
Commit: f1b07bd25dfad64b0167beb15359ae573aecd2cc
Date: 2023-10-10T23:48:05.904Z
Electron: 25.8.4
ElectronBuildId: 24154031
Chromium: 114.0.5735.289
Node.js: 18.15.0
V8: 11.4.183.29-electron.0
OS: Windows_NT x64 10.0.19045