DBEdit uses a single connection string per workbook created with a workbook.
You can change the data provider and database credentials. However, you cannot change the server platform, i.e., change SQL Server to Oracle Database.
To change a connection, click Data, Workbook Connection..., or press Ctrl-F7.
In the first step, select a provider.
The wizard shows providers for the actual server platform, as for SQL Server in this example.
In this step, specify new database credentials.
DBEdit checks the connection in the background and enables the Finish button if succeeded.
If the Finish button is disabled, click the Test Connection button to test the connection and update the state.
In the first two steps, the wizard changes the connection only, but not refreshes data.
You can refresh data yourself using Data, Refresh All (Ctrl-Alt-F5) or Data, Refresh Selected... (Ctrl-Shift-F5).