Deltek PPM Datasource Management Data Tool Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Configure the Default OLE DB Provider Connection

Use this procedure to configure the default OLE database provider connection.

If you select any of the default OLE DB providers in the Provider list, the Data Link Properties dialog box displays.

To configure the default OLE DB provider connection:

  1. On the Connection tab, perform the appropriate set of actions:
    • If you are using a SQL Server or a SQL Server Native Client, perform the following actions:
      • In the Select or enter a server name field, select a server or enter the location of the server where the database you want to access is located.
      • Select the Use Windows NT Integrated security option to access the database connection using the login information obtained from the Windows NT network security.
      • Select the Use a specific user name and password option and enter the user ID and password to use for authentication in the User name and Password fields.
      • Select the Blank password option to enable the specified provider to return a blank password in the connection string, or select the Allow saving password option to allow the password to be saved with the connection string.
      • In the Select the database on the server field, enter or select the name of the database you want to access.
      • In the Attach a database file as a database name field, enter or select (using the Browse button) the database filename to attach.

      • In the Using the filename field, enter the database connection.

    • If you are using a SQL Server Native Client, perform these additional steps:
      • Click the All tab, select the property specified below, click Edit Value, and perform the required action in the Edit Property dialog box:
        • For Data Type Compatibility, set Property Value to 80.

        • For Initial File Name, click Reset Value.

        • For Integrated Security, click Reset Value.
        • For Persist Security Info, select True in the Property Value drop-down list.
        • For Server SPN, click Reset Value.
        Note: You must click Reset Value even if the Property Value field is blank.
    • If you are using an Oracle Server, perform the following actions:
      • In the Enter a server name field, enter the location of the server where the database you want to access is located.
      • In the User name field and Password field, enter the user ID and password to use for authentication when you log onto the connection.
      • Select the Blank password option to enable the specified provider to return a blank password in the connection string, or select the Allow saving password option to allow the password to be saved with the connection string.
    • If you are using a Microsoft OLE DB Driver for SQL Server, perform the following steps:
      • If you select the SQL Server Authentication option, perform the following actions:
        • Clear the Blank password option and select the Allow saving password option.
        • Enter your password in the Password field.
      • Click the All tab.
      • Select Data Type Compatibility, click Edit Value, set it to 80, and click OK.
  2. Click Test Connection to confirm that the connection to your database connection works.
    The PPM Datasource Management Tool displays a message box that confirms the database connection.
  3. Click OK.
    If the PPM Datasource Management Tool is unable to establish a connection, return to the General tab and check your settings, or consult your database administrator.