can't use vscode-sqltools

[zcmarkyoung]

hi guys,I want use sqltools in vscode(in windows10) to connect sqlite,for this I install extension sqlite driver in markplace then add new connection the vscode tips I should "SQLTools: Installing "sqlite3@5.1.1". Please wait until it finishes. Check the opened terminal for more info." but it seems not work correctly. I install sqlite3 manually. first I install nodejs then I install sqlite3. It can't build correctly.So I download "napi-v6-win32-unknown-x64.tar.gz"(5.1.1) from `npm install napi-v6-win32-unknown-x64.tar.gz

npm ERR! code ENOENT

npm ERR! syscall open

npm ERR! path C:\Users\Administrator\AppData\Local\npm-cache_cacache\tmp\HZRTwy/package.json

npm ERR! errno -4058

npm ERR! enoent ENOENT: no such file or directory, open 'C:\Users\Administrator\AppData\Local\npm-cache_cacache\tmp\HZRTwy\package.json'

npm ERR! enoent This is related to npm not being able to find a file.

npm ERR! enoent`

so what's the problem?

[gjsjohnmurray]

Did you use the information and advice at https://vscode-sqltools.mteixeira.dev/en/drivers/sq-lite?

[RandomFractals]

@zcmarkyoung I use SQLite on Windows 10 too for testing and it works. Make sure you have this setting in your user or project workspace vscode settings:

{
  "sqltools.useNodeRuntime": true
}

[SchoolyB]

@zcmarkyoung What helped me was updating the extension to 5.1.1. Also double checking my settings.json file for the accurate useNodeRuntime value

[zcmarkyoung]

I set useNodeRuntime value ,but it still install sqlite3@5.1.1 also I can't install correctly

[gjsjohnmurray]

@zcmarkyoung It shouldn't have been necessary to install nodejs and sqlite3 manually, and I guess it's possible those steps have left your system in an unusual state.

What does your Terminal profiles list look like?

When you pick Select Default Profile what does the top-centre quickpick look like?

Screenshots can be pasted direct into a GH comment at the website.

Assuming you have a PowerShell option (not to be confused with Windows PowerShell), please pick that as your default. Then I suggest you uninstall the SQLTools SQLite driver extension, restart VS Code a couple of times, then install that driver again from Marketplace.

I noticed that your path mentions "Administrator". Is your VS Code installation a System Setup or a User Setup? Does the suffiix "[Administrator]" appear in your VS Code window title?

Please also go to the About option of VS Code's Help menu, click the Copy button on the dialog, then paste the info into your response on GH.