SqlTools

[fergusrobertson]

How should the settings.json file look for a db2 connection. I want to use a connection string

[lucashancock]

Here is an example. There's connection string functionality as of now, but the tool essentially builds the connections string in the background.

settings.json

{
  "sqltools.connections": [
    {
      "previewLimit": 50,
      "driver": "Db2 Driver for SQLTools",
      "name": "demo",
      "server": "servername",
      "port": 25010,
      "database": "db",
      "username": "user",
      "password": "password"
    }
  ],
}

If you'd like connection string input functionality, I can potentially add that. Or feel free to pull request.

Let me know if you need additional help.

[fergusrobertson]

So I'm trying to connect to an AS/400 Infinium Connection and I know db2 is the closest connector.

Provider=IBMDA400;Data source=x.localsite.com;User Id=username;Persist Security Info=True;Password=pwd

[lucashancock]

Do you have db2connect?