7.5

l An SQLServer driver must be installed on the system (this is available by default in any supported version of Windows)
l The currently logged on user must have access to the SQLServer instance through the network.
l A database must be created on the SQLServer. It is suggested to call the database Search.
l Ausername and password must be defined in the user options and this username 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 PlanetPress 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.
PlanetPress 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 loca-
tion on the hard drive. While a network path or mapped drive can be typed in manually in this dialog, it is strongly rec-
ommended to use a search profile on a local drive, for performance reasons.
PlanetPress Search, when opened, will automatically load the default search profile (ppsearch.prf)located in
C:\Documents and Settings\(current login username)\Application Data\Objectif
Lune\PlanetPress Suite X\PlanetPress Search\ . If the search profile is located somewhere
else, it will need to be opened manually each time PlanetPress Search is opened.
Once your profile is created, additional actions may be done on the profile:
l To share a profile on the network between multiple users, see Sharing A Profile On The Network.
l To edit the profile manually to change additional options, see Search Profile Contents Line by Line.
Create a New Search Profile that Uses an Access Database
The procedures here describe how to create a new search profile that uses an Access Database.
If you are creating a new search profile in a network installation, make sure you log on with the appropriate privileges to be
able to save and edit the search profile. In network installations, restrictions on who can create and/or edit search profiles
may be imposed to ensure the integrity of PlanetPress Search databases. See "Database Considerations in a Network Instal-
lation" (page 42).
Though an Access Database can be located on a network drive, it should never be shared between multiple search
profiles or multiple users. Doing so will most likely corrupt the Access database or simply not work as Access data-
bases are meant for nonconcurring use.
To create a new search profile that references a Microsoft Access database:
1. In PlanetPress Search, choose File | New | Access Profile.
The New Profile dialog box appears.
2. In the New Profile dialog box, navigate to the folder in which you want to save the new search profile, enter the
name under which you want to save the new search profile and click Save.
PlanetPress Search prompts you to specify a folder in which to create the database.
3. Click OK and use the Select Directory dialog box that PlanetPress Search displays to select the folder in which to create
the database. You can enter the path in the Selected folder box, or use the Current drive and Folders list to navigate to
the folder.
In a standalone installation, the folder must be one for which the user has both read and write access. For optimum per-
formance in this case, a folder on the local drive is recommended.
Search Profiles And Databases
©2010 Objectif Lune Inc - 20 -