Schema and tables not showing up for SQL server hosted on ubuntu server

[umairshariff23]

Describe the bug
I have a SQL server hosted on an ubuntu server and connected to vscode via SQLTools. I created a test database called hospital_db, a schema called hospital, and a table called test with values from 1 to 10. I can run the script select * from test and call the list of numbers from the table. However, I cannot see the schema and table show up under the database in the left pane.

Extract from the Output Channel Log
[1683145884364] INFO (ext): EXECUTING COMMAND => sqltools.getConnections [1683145884365] INFO (ls): REQUEST RECEIVED => connection/GetConnectionsRequest [1683145884367] INFO (ext): EXECUTING COMMAND => sqltools.getChildrenForTreeItem [1683145884368] INFO (ls): REQUEST RECEIVED => connection/GetChildrenForTreeItemRequest [1683145884368] INFO (ext): EXECUTING COMMAND => sqltools.getChildrenForTreeItem [1683145884369] INFO (ls): REQUEST RECEIVED => connection/GetChildrenForTreeItemRequest [1683145884387] INFO (ext): EXECUTING COMMAND => sqltools.getChildrenForTreeItem [1683145884388] INFO (ls): REQUEST RECEIVED => connection/GetChildrenForTreeItemRequest [1683145884388] INFO (ext): EXECUTING COMMAND => sqltools.getChildrenForTreeItem [1683145884389] INFO (ls): REQUEST RECEIVED => connection/GetChildrenForTreeItemRequest [1683146116024] INFO (ext): EXECUTING COMMAND => sqltools.showOutputChannel

To Reproduce
Steps to reproduce the behavior:

1. Create a database
2. Create a schema
3. Create a table
4. Refresh the connection or disconnect and reconnect to the server

Expected behavior
I expect to see a full list of all the schemas and tables for that schema under each database

Screenshots

Desktop (please complete the following information):

• SQLTools Version [e.g. v0.27.1]
• VS Code Version: [e.g 1.77.3]
• OS: Windows
• Driver:
  • PostgreSQL/Redshift
  • MySQL/MariaDB
  • [ x ] MSSQL/Azure
  • SQLite
  • Other? Which...
• Database version: mssql/server:2019

[gjsjohnmurray]

Does #710 (comment) help? Maybe you need to specify database hospital_db explicitly in your connection definition.