Reputation: 1729
Running Dbeaver 21.3.0 on ubuntu linux 21.1. The problem I have is that when trying to execute a query I get a "no active connection error". However in the Database navigator screen I have an active remote ms-sql-server connection, can see the overall database, and all files in it, can check all of their column properties etc. How do I get this particular script to associate with that particular database? I'd also like to have it automatically associated the next time I open the script?
Upvotes: 34
Views: 47906
Reputation: 841
Picking an active connection in the menu bar (SQL Editor > Set active connection) solves the issue.
Upvotes: 73
Reputation: 81
Updating @Tomek's answer: After choosing set active connection you need to select the DB you want to work with. And it appears there is no way for now to auto-link your SQL script with certain DB, so you need to choose active connection for any new or opened SQL script.
Upvotes: 8