vscode-sqlite
vscode-sqlite copied to clipboard
AlexCovizzi
Failed to open database
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
I have the exact sane problem on Manjaro (archlinux based), the same versions of vscode and SQLite!!
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.
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
