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.

[EugZol]

Same error in 0.23.0.

[AngelinCalu]

This still seems to be an issue on the current version.

[MarcelSchuermann]

This still seems to be an issue on the current version.

Agree, the error still exists. Any solutions / workarounds?

[pau1tuck]

This is still a problem. Running the contributed command: 'sqltools.addConnection' failed. (mariadb on Arch Linux)

[malocan]

The same issue. Still can not go to the next step of creating new connection

[aecliam]

same issue with me too. I've been trying to disable and enable like what others have said but it's still an error.

[VolpiGiuliano]

Same issue, and it always shows this message

[gjsjohnmurray]

@RagionierBolo yours looks more like #668

[seeejj]

I'm also facing this issue today in 2022. Any luck?

[gjsjohnmurray]

@seeejj did you try the suggestion at https://github.com/mtxr/vscode-sqltools/issues/668#issuecomment-993403972 to delete one instance of a duplicate connection definition?

[Eruasa]

@seeejj did you try the suggestion at #668 (comment) to delete one instance of a duplicate connection definition?

Doesn't sadly work if you don't have any connections at all. And I don't know how I can manually add a connection, since I have trouble understanding the syntax.

EDIT Just restarted VSCode, and now it works, no idea what changed, but I did restart it before like every time after I install an extension,

[seeejj]

@gjsjohnmurray Same thing to @Eruasa happened with me. Had restarted repeatedly when I was actively trying to fix it, it didn't work, and one day it did again.

I pretty much gave up trying to get VSCode to work, and didn't use SQLTools for a couple of weeks. Then one day, after many VSCode restarts since the day I had this issue, it suddenly worked again.

[Vilgot-thy]

Hi. Have the same problem but I'm geting this error

[gjsjohnmurray]

@Vilgot-thy does the problem still happen after a complete reboot of the workstation? Perhaps https://github.com/microsoft/vscode/issues/125993

[Vilgot-thy]

Yes that did fix the error, but I stile only get this

edit: seems to work now thanks you for the help

[gjsjohnmurray]

Starting with today's 0.27.1 release it should no longer be possible to define connections with duplicate IDs using the UI.

[smm-h]

You guys should check out this thread on SO:

https://stackoverflow.com/questions/50093144/mysql-8-0-client-does-not-support-authentication-protocol-requested-by-server

The top answer worked for me.

[carolinaqvargas]

Hi everyone, could you please help me with this issue? Successful connections won't appear on the side bar. Even after I click 'connect now' Thank you!

[gjsjohnmurray]

@carolinaqvargas from Command Palette (F1) please run Preferences: Open User Settings (JSON) and review the sqltools.connections object. Are there any duplicate names?

Temporarily disable the object by renaming it, e.g. to Xsqltools.connections. Save the change, then restart VS Code. Define a new connection, testing it when prompted. Does the tree now show this entry?