Vscode-sqltools: Can't add new connection

[alexey-rio]

Hi guys,

I've installed SQLTools extension for VS Code and when I am trying to add new connection - nothing happens.
I can't see any errors popping up.
Hence I've been unable to add a new connection to a DB.

Connection assistant is not being displayed.

VS Code version: 1.47.1 (system setup)
SQLTools version: 0.22.10
OS: Windows 10 1809

[rimutaka]

While this problem is being looked into you can add a new connection manually to sqltools.connections in settings.json as described in https://vscode-sqltools.mteixeira.dev/driver/postgresql.

It probably won't take you far, though. Running queries returns a blank SQLTools Results pane. Looks like something's seriously broken ...

Query: select * from t_list

Output: a blank SQLTools Results pane

Log output:

['ext:main:info'] EXECUTING => sqltools.executeQuery
['ext:main:info'] EXECUTING => sqltools.getConnections
['ext:main:info'] EXECUTING => sqltools.getConnections
['ext:main:info'] EXECUTING => sqltools.getChildrenForTreeItem
['ext:main:info'] EXECUTING => sqltools.getChildrenForTreeItem

[LuisEmilioJuarez]

got this problem too please if you could look up into it thanks a lot

[hriziya]

I am facing the same problem. may be something is broken in the latest version?

[hriziya]

I have added connection manually by modifying the sqltools.connections in settings.json and then again I can not see the query result.

[jimrandell]

Same with me (I hope this can be resolved, this is my fav SQLtool

• SQLTools

  • Version: v0.22.10

• VS Code

  • Version: 1.47.1 (user setup)
  • Commit: 485c41f9460bdb830c4da12c102daff275415b53
  • Date: 2020-07-13T22:42:53.386Z
  • Electron: 7.3.2
  • Chrome: 78.0.3904.130
  • Node.js: 12.8.1
  • V8: 7.8.279.23-electron.0
  • OS: Windows_NT x64 10.0.18362

[gabrielcardoso30]

Ótima tarde a todos! Eu também estou com o mesmo problema... :(

[gabrielcardoso30]

Fiz um downgrade de versão, resolveu, agora consigo usar :D
Coloquei na versão 0.22.9

[wscatao]

Mesmo problema aqui? Como fez o downgrade @gabrielcardoso30 ?

[bRaInT00T]

Duplicate of #639

[mtxr]

Fixed on v0.22.11.