7.5

Table Of Contents

DatabaseTimeout=300

[PathList]

Path1=F:\sales\letters

Sample Connection Strings

The following are sample DatabaseDirectory entries that contain connection strings for an SQL Server database. The first in

each pair presents the case where the user name and password on the database is the same user name and password the

user uses to log on to their computer and run PlanetPress Search. The second in each pair presents the case where the user

name and password on the database is different from the user name and password the user uses to log on to their computer

and run PlanetPress Search.

DatabaseDirectory=Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Data Source=SQLServ01

DatabaseDirectory=Provider=SQLOLEDB.1;Persist Security Info=False;User ID=bob;Password=qo5F8DgsYTk;Data

Source=w2k-websvr

Sharing A Profile On The Network

If you are creating a search profile for a network installation, either exit PlanetPress Search or switch to a different search pro-

file (see Things to Remember for an explanation of why this is necessary), then open the search profile you just created in a

text editor such as TextPad and make the following modifications:

l Set the value of the ReadOnly entry to 1 (ReadOnly=1) to prevent refreshes and rebuilds of the database through this

search profile.

l Adjust the DatabaseDirectory entry if necessary. It is recommended that you use the UNC name (\\serv-

ername\sharename\path\filename). This eliminates the problem of different users mapping the same drive to

different drive letters. For example, use DatabaseDirectory=\\MyServer\MyDbase rather than Dat-

abaseDirectory=G:\\MyDbase.Note that if you do use drive letters, a plus sign (+) in place of the drive letter indi-

cates the database is on the same drive as the search profile that references it. For example:

DatabaseDirectory=+:\\MyDbase.

Once you complete the modifications, save the file and exit the text editor. You may also want to review "Database Con-

siderations in a Network Installation" (page 42) and verify the appropriate permissions are set to ensure the integrity of

both the search profile and the database it references.

Database Structure

To produce valid SQL statements you will need to understand the contents of the database tables and their relationships to one

another.

For more information submitting an SQL Search Type, see "Perform a Search Using an SQL Query" (page n).

Advanced Concepts