Changing Workbook Connection

Changing Workbook Connection

DBEdit uses a single connection string per workbook created with a workbook.

You may 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.

Step 1. Select Provider

In the first step, select a provider.

The wizard shows providers for the actual server platform, as for SQL Server in this example.

Step 2. Connect to Database

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.

Step 3. Refresh Data

In the first two steps, the wizard changes the connection only, but not refreshes data.

You may refresh data yourself using Data, Refresh All (Ctrl-Alt-F5) or Data, Refresh Selected... (Ctrl-Shift-F5).

This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.