August 18, 2021 at 5:52 pm
Recently I've noticed that Azure Data Studio (ADS) doesn't produce any results when I run it. I'm working on a SQL Script to update some lookup tables. I've been putting in lots of PRINT statements, performing SELECTs at various places, etc. Then when I get to a point of where I want to test it, I press the play button in ADS.
Nothing happens.
Nothing is written to the Results pane. Nothing is written to the Messages pane.
Why is that?
Kindest Regards, Rod Connect with me on LinkedIn.
August 19, 2021 at 8:46 am
No clue at the moment.
What version of Azure Data Studio are you using?
There was a bug https://github.com/microsoft/azuredatastudio/issues/8509
August 19, 2021 at 8:59 am
I can't say I've ever run into this problem, and I've been daily driving ADS for at least a couple years. It almost sounds like you aren't actually connected to an instance and it's not prompting you to connect or something.
If you are running the latest version (there was a new release last night), have you tried uninstalling and reinstalling it?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
August 19, 2021 at 2:39 pm
No clue at the moment.
What version of Azure Data Studio are you using?
There was a bug https://github.com/microsoft/azuredatastudio/issues/8509%5B/quote%5D
I'm using version 1.32.0 for 64-bit Windows.
Kindest Regards, Rod Connect with me on LinkedIn.
August 19, 2021 at 2:42 pm
I can't say I've ever run into this problem, and I've been daily driving ADS for at least a couple years. It almost sounds like you aren't actually connected to an instance and it's not prompting you to connect or something.
If you are running the latest version (there was a new release last night), have you tried uninstalling and reinstalling it?
I've just checked for updates - there are none. I'm going to look for any issues related to this on GitHub. If there are none, then I'll create my own.
Kindest Regards, Rod Connect with me on LinkedIn.
August 19, 2021 at 3:11 pm
Sounds odd. It's working on my machine, both SQL Server & PostgreSQL.
Connection issue?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 20, 2021 at 2:01 pm
I don't think so, Grant. I often have another query window open in ADS, so I can do a quick SELECT to check something, while working on the SQL script in the other query window. The ad hoc queries work fine. And normally, if I'm not connected to a database in ADS, hitting the Play button brings up a popup complaining about not being connected. That doesn't happen, either.
Yesterday I entered feedback in ADS on this issue. I was sent to GitHub. There I decided to enter the complete SQL Script I've been working on in an issue on ADS, in GitHub. (I left out some things from the script I felt shouldn't be put in a GitHub issue.) Doing so I realized there might be a cause about this, related to the database. It would be kind of a special case, dependent upon my writing a SQL script instead of an ad hoc query, but here goes. None of the tables in this database have any primary key. And none of the tables have foreign keys to any other table. For all intents and purposes, whoever designed this database could have used flat files or Excel spreadsheets, because all the database logic is performed by the app. I don't know why whoever designed this database, didn't bother putting in any keys or relating any table with any other table. (There are a lot of other strange things about this database and application which I could author an article on, so I won't go into it further here.) Perhaps, not having any primary or foreign keys is making it difficult for ADS to produce any results or messages from the SQL Script when I run it. That's just a guess.
Kindest Regards, Rod Connect with me on LinkedIn.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply