Edit Data Source Dialog Box

Use this dialog box to edit an existing data source or database connection.

This dialog box contains two tabs: General and Advanced.

General Tab

Use this tab to set the required connection properties.

Field	Description
Name	This field displays name of the data source you want to update. It is read-only.
Schema	You can change the schema (database name) in this field. This field is optional and is typically used only with Oracle. However, this field is required if the Oracle Account used has access to more than one schema in the Oracle database. If you do not enter a schema name, the DATASOURCES.DAT file must identify an Initial Catalog for the data source.
Provider	This field displays a list of available providers to use when the tool connects to the database.
Configure	Click this button to display either the Data Link Properties dialog box or the Connection Properties dialog box. If the provider is any of the following, the Data Link Properties dialog box displays. Microsoft OLE DB Provider for SQL Server Microsoft OLE DB Driver for SQL Server Oracle Provider for OLE DB SQL Server Native Client If the provider is Oracle ODP.NET, the Oracle Data Provider for .NET Connection Properties dialog box displays. If the provider is SQL Server .NET Framework, the .NET Framework Data Provider for SQL Server Connection Properties dialog box displays.

Use this tab to set the following settings:

Field	Description
Database is Unicode	Select this option if the scripts for creating tables default to a Unicode installation.
Extended Properties	You can set or change extended data source properties for a database in this field.

These button display when you navigate to either tab:

Field	Description
OK	Click this button to return to the PPM Datasource Management Tool dialog box and add the newly defined data source to the list. The new data source is selected by default.
Cancel	Click this button to disregard any change and return to the PPM Datasource Management Tool dialog box.