Create a New Search Profile that Uses an SQL Server Database

This procedure describes how to create a search profile that uses an SQL Server database.

Pre-Requisites for SQL Server database connectivity:

  • An SQL Server driver must be installed on the system (this is available by default in any supported version of Windows)
  • The currently logged on user must have access to the SQL Server instance through the network.
  • A database must be created on the SQL Server. It is suggested to call the database Search.
  • A username and password must be defined in the user options and this user name must have access to the SQL Server and its Search database (see Set User Options).

To create a new search profile that references an SQL Server database:

  1. In OL Connect Search, choose File | New | SQL Server Profile.
  2. In the Server name dialog, type in the server name or IP Address of your SQL Server, then click OK. If the SQL Server has an instance name, it should also be entered after a backslash (for example: localhost\SQLEXPRESS )
  3. In the Database name dialog, type in the name of the database to be used, then click OK.
    OL Connect Search will now attempt to logon to the server and database specified.
  4. If the connection is successful, a Save As dialog appears. Use this dialog to save the Search Profile file to a specific location on the hard drive. While a network path or mapped drive can be typed in manually in this dialog, it is strongly recommended to use a search profile on a local drive, for performance reasons.

    Note: OL Connect Search, when opened, will automatically load the default search profile (ppsearch.prf) located in C:\Users\(current login username)\AppData\Roaming\Objectif Lune\PlanetPress Workflow 8\PlanetPress Search\ . If the search profile is located somewhere else, it will need to be opened manually each time OL Connect Search is opened.

Once your profile is created, additional actions may be done on the profile: