7.5
2014-03-28

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