search

mtxr / vscode-sqltools

Database management for VSCode
https://vscode-sqltools.mteixeira.dev?utm_source=github&utm_medium=homepage-link
MIT License
1.52k stars 306 forks source link

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

Open umairshariff23 opened 1 year ago

umairshariff23 commented 1 year ago

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 image

Desktop (please complete the following information):

gjsjohnmurray commented 1 year ago

Does https://github.com/mtxr/vscode-sqltools/issues/710#issuecomment-1253820213 help? Maybe you need to specify database hospital_db explicitly in your connection definition.