Changing Connections Is Not Supported for Non-Empty Query Documents

Attempting to change the connection for a query document may result in the following error:

"Cannot change the connection for a non-empty query document"

As a result, the connection cannot be switched to another server or environment while the document contains a query or an execution is in progress.

Cause

This is the expected behavior. Changing the connection for a query document is not supported if the document already contains a query or if the query is currently being executed.

Workaround

Before changing the connection:

1. Ensure that the current query execution has finished.
   
2. If the query is still running, stop it by clicking Stop Execution on the toolbar.
   
3. Once execution has completed, the connection can be changed using the Connection drop-down list.
   

Note: If the same query needs to be executed against another server or environment, it is recommended to open a new query document and select the required connection there.

Additional Information

The ability to select a database directly within the query document, similar to the functionality available in dbForge Studio for SQL Server, is planned for future releases.

• Related Articles

• How to Work in Power Query Using ODBC Driver

  1. Connect to an ODBC Source In Power BI Desktop, go to the Home tab and click on Get Data to connect to an ODBC source. From the list of available connections, select the DSN connection that you created in the ODBC Administration tool. You can learn ...

• CPU Utilization Metric Is Empty or Shows 0 in SQL Monitor

  The CPU Utilization metric in SQL Monitor is not displayed or always shows 0. The same SQL Monitor instance may work correctly for other SQL Server instances. For example, CPU utilization can be displayed normally on SQL Server 2016 while remaining ...

• Error: “Feature is not supported” (license key validation in .NET Standard)

  This error occurs when Devart .NET Standard assemblies cannot validate a license key at runtime. The guidance applies to all dotConnect providers. After migrating a working .NET Framework application to .NET Core / .NET 6–9 and referencing NuGet ...

• Error: "Unsaved documents cannot be cut or copied to the clipboard from the miscellaneous files project" in SSMS

  When attempting to copy text from the Find and Replace window in SQL Server Management Studio (SSMS), the following error message may appear: "Unsaved documents cannot be cut or copied to the clipboard from the miscellaneous files project. You must ...

• Excel Add-ins. Slow Data Extraction (Database Providers)

  This article is for Excel Add-ins (Databases). Navigation: Supported Data Sources → Supported databases: Data loading into Excel may work noticeably slower compared to executing the same query in other tools. Performance can be improved by adjusting ...