Cannot Visualize My Azure Database

ddieppa commented 4 years ago

Expected Behavior

Click on the Schema Visualization icon and see the db diagram

Current Behavior

Click on the Schema Visualization icon and got this error:

Errors:
Error getting data: Failed to connect to connectionstringtoazuredb - getaddrinfo ENOTFOUND  connectionstringtoazuredb 
Could not build chart from the recived data
{"databaseRaw":[],"errors":["Could not build chart from the recived data"],"status":"ERROR"}

Context (Environment)

Azure Data Studio Version: 1.20.1 (user setup) Commit: fe6312306647441b30102a64bb43abb06ebcf2be Date: 2020-07-17T02:39:41.016Z VS Code: 1.47.0 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.17763

Detailed Description

R0tenur commented 4 years ago

Is the db running on port 1433? If not, there are a recently added release that is not yet linked from the store.

https://github.com/R0tenur/visualization/releases/tag/v0.4.0

ddieppa commented 4 years ago

@R0tenur yes it is running on port 1433 this is the format of the connection string: tcp:ourserver.database.windows.net,1433

R0tenur commented 4 years ago

Can you check if the latest fix is working? https://github.com/R0tenur/visualization/releases/tag/v0.5.0 I have not been able to reproduce the error

ddieppa commented 4 years ago

I did install the latest fix, and not getting the error but the schema never appears stay in loading forever

R0tenur commented 4 years ago

Can you show how you ar filling in the credentials view? Ofc not the real credentials but the structure in the input fields.

ddieppa commented 4 years ago

here is a picture of the connection details, ofc not the real ones

R0tenur / visualization