DevDb Terminal Window Not working with SqlExpress

[uptondev]

Extension Version

v2.6.3

OS and Version

Windows 10

VS Code Version

v1.100.2

Database name and Version

Microsoft SQL Server 2022 (RTM) - 16.0.1000.6 (X64) Oct 8 2022 05:58:25 Copyright (C) 2022 Microsoft Corporation Express Edition (64-bit) on Windows 10 Pro 10.0 (Build 19045: ) (Hypervisor)

Steps to reproduce

Steps to Reproduce:

1. Configure connection in .devdbrc file -

[   {
                "name": "My Sql Server",
                "type": "mssql",
                "host": "localhost",
                "port": 1433,
                "username": "dumdumRO",
                "password": "ROdumdum",
                "database": "TestDatabase",
                "options":  {
                        "trustServerCertificate": true
                }
}  ]

2. Open DevDb panel in Terminal window and click the config file connections. This succeeds.
3. In Sql Profiler I see DevDb runs a query to get table list. This succeeds and the window now shows the table names on the left.
4. While jokes are displaying, I click the table name, nothing happens and jokes keep playing...
5. In my Sql Profiler I see no queries were sent to the database.
6. In the DevDb panel of Terminal's Output window I see this...

[Init] Adonis PostgreSQL (Lucid ORM) useable in workspace: no 
[Connector - Config file provider] Attempting to connect to database: dialect=mssql, host=localhost, port=1433, username=dumdumRO, database=T***** 
[Init] Config File useable in workspace: yes 
[Init] Available providers: SQLite Database File Picker, Config File 
[Comm - mssql- undefined] Tables available: 1
[Comm - mssql- undefined] Tables available: 1
[Comm - mssql- undefined] Tables available: 1

Expected behavior

I expect the DebDb panel to display the data like the screenshots in the documentation...

Screenshots

Additional context

No response

[myheisenberg]

I agree, it’s not working for me either. The extension seems to be broken.

``workbench.desktop.main.js:2751 [damms005.devdb]Undefined binding(s) detected when compiling SELECT. Undefined column(s): [0, 1, 2, 3] query: select count(*) as [count] from [TestTable] where [0] = ? and [1] = ? and [2] = ? and [3] = ?

[myheisenberg]

I found a workaround: downloading an older version.
If you download version 2.4.2, the issue is resolved.

Hopefully the developers will fix this bug soon.