Modify and Delete Data Sources

You can modify and delete data sources using the Database Explorer app. For ODBC drivers, you create data sources using the ODBC Data Source Administrator dialog box. For JDBC drivers, you create data sources using the JDBC Data Source Configuration dialog box. You can modify and delete data sources using the same dialog boxes.

Modify Data Sources

Use the Database Explorer app to modify data sources by following these steps.

ODBC Data Sources

  1. After opening the Database Explorer app, select Configure Data Source > Configure ODBC data source. The ODBC Data Source Administrator dialog box opens. For details about locating this dialog box on your computer, see Driver Installation.

    Alternatively, run the configureODBCDataSource function.

  2. In the ODBC Data Source Administrator dialog box, select the data source to modify. Click Configure.

  3. Modify the settings as needed, and close this dialog box.

JDBC Data Sources

  1. After opening the Database Explorer app, select Configure Data Source > Configure JDBC data source. The JDBC Data Source Configuration dialog box opens.

  2. Click Edit. In the list, select the data source to modify. Click OK.

  3. Modify the settings in the JDBC Data Source Configuration dialog box. If you do not change the data source name, the Database Explorer app overwrites the existing data source with the new settings. To avoid overwriting the existing data source, enter a new data source name.

  4. Click Test. The Test Connection dialog box opens. Enter the user name and password for your database. Click Test.

    If your connection succeeds, the Database Explorer dialog box opens and displays a message indicating a successful connection. Otherwise, it displays an error message.

  5. Click Save. The JDBC Data Source Configuration dialog box displays a message indicating the data source is saved. Close this dialog box.

Delete Data Sources

Use the Database Explorer app to delete data sources by following these steps.

ODBC Data Sources

  1. After opening the Database Explorer app, select Configure Data Source > Configure ODBC data source. The ODBC Data Source Administrator dialog box opens.

  2. Select the data source to delete.

  3. Click Remove and close this dialog box.

JDBC Data Sources

  1. After opening the Database Explorer app, select Configure Data Source > Configure JDBC data source. The JDBC Data Source Configuration dialog box opens.

  2. Click Edit.

  3. In the list, select the name of the data source to delete. Click OK.

  4. Click Delete and click Yes.

    The JDBC Data Source Configuration dialog box displays a message indicating a successful deletion.

  5. Close this dialog box.

See Also

Apps

Related Topics