search

mtxr / vscode-sqltools

Database management for VSCode
https://vscode-sqltools.mteixeira.dev?utm_source=github&utm_medium=homepage-link
MIT License
1.5k stars 302 forks source link

Cannot add new connection #972

Closed Stycos closed 2 years ago

Stycos commented 2 years ago

I cannot create a new connection. When I click on the circled locations in VS code there is no response.

image

If I use Ctrl+Shift+P then type in "SQLTools Management: Add New Connection" I get the error seen above.

Expected behavior See a list of Drivers

Desktop:

gjsjohnmurray commented 2 years ago

Please go to the Output view (one way is F1, start typing "Focus on output" and choose the command). In the dropdown on Output view choose "SQLTools". Use the button by the dropdown to clear the output. Then use Command Palette (F1) to run Developer: Reload Window. When the reload has completed, check the SQLTools Output for error information and paste it here.

Stycos commented 2 years ago

I just get the following:

[1663279824883] INFO (ext): SQLTools is starting [1663279824901] INFO (ext): initializing language client... [1663279824902] INFO (ext): Detecting node path (if this stalls check Terminal view for the stuck session and kill it)... ns: "lc"

gjsjohnmurray commented 2 years ago

Please inster the following line as line 2 of your settings.json file, which you can open by running Preferences: Open User Settings (JSON) from Command Palette:

"sqltools.useNodeRuntime": false,

Save the change, restart VS Code, and see if the problem remains.

Stycos commented 2 years ago

That worked! Thank you!

gjsjohnmurray commented 2 years ago

@Stycos thanks for confirming this as a resolution. We have released 0.25.1 which reverts the default of this setting. It is now false, which is how it was in 0.24 and earlier versions. The only official driver that needs the setting to have a different value is the SQLite one.