Modify and Delete Data Sources

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

Modify Data Sources Interactively

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

ODBC Data Sources

1. Open the Database Explorer app. In the Data Source section of the Database Explorer tab, select Configure Data Source > Configure ODBC data source. The ODBC Data Source Administrator dialog box opens.

   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.

JDBC Data Sources

1. Opening the Database Explorer app. In the Data Source section of the Database Explorer tab, 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 app displays a message indicating a successful connection. Otherwise, it displays an error message.

5. Click Save.

Modify Data Sources Programmatically

Use the command line to modify data sources by following these steps.

ODBC Data Sources

Modify an ODBC data source using the ODBC Data Source Administrator dialog box. To access this dialog box, see the configureODBCDataSource function.

JDBC Data Sources

1. Edit an existing JDBC data source using the databaseConnectionOptions function.

2. Set JDBC connection options using the setoptions function. Or, you can set properties in the SQLConnectionOptions object using dot notation.

3. Add JDBC driver-specific connection options using the setoptions function. Or, remove existing JDBC driver-specific options using the rmoptions function.

4. Test the database connection using the testConnection function.

5. Save the JDBC data source using the saveAsDataSource function.

Delete Data Sources Interactively

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

ODBC Data Sources

1. Open the Database Explorer app. In the Data Source section of the Database Explorer tab, 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.

JDBC Data Sources

1. Open the Database Explorer app. In the Data Source section of the Database Explorer tab, 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.

Delete Data Sources Programmatically

Delete an ODBC data source using the ODBC Data Source Administrator dialog box. To access this dialog box, see the configureODBCDataSource function.

To delete a JDBC data source, specify the name of the data source in the deleteDataSource function.