Adobe 65029902 User Guide - Page 16

USING ROBOHELP SERVER 8 13 Managing the server ODBC Administrator Enables you to create or modify a data source. 3 Enter the user name and password. 4 Click Test Connection. 5 If the Test Connection is successful, a message appears. Click Save. 6 Exit or close the window. RoboHelp Server databases The RoboHelp Server connects to Oracle (9i or higher), Microsoft Access, SQL Server 2005, or Microsoft SQL Server Express Edition. Microsoft Access Applications Rewritten in Visual Basic for applications. A database solution written in Microsoft Access integrates with tools like Excel and Word. Microsoft Access stores information using the Jet database server. It uses a file server model of computing in which all logic is with the client application. Note: You can use the Microsoft Access database for internal purposes as it does not support multi-threading. Microsoft SQL This database is a relational database management system capable of handling large amounts of data and many concurrent users. When a client application requests data, the server retrieves or updates the data. SQL Server can roll back transactions. It does not commit a partially entered record to the database. Oracle This system provides for the definition, storage, and management of data in a centralized area. It supports client-server environments, large databases, space management, concurrent database users, high transactionprocessing performance, openness, compliance with industry standards, manageable security, portability, compatibility, and connectivity. Microsoft SQL Server Express Edition Microsoft SQL Server is a relational database management system (RDBMS) produced by Microsoft. Its primary query languages are MS-SQL and T-SQL. Configuring databases using the configuration files You can use the RoboHelp Server.properties file (located at /WEB-INF folder) to configure a database. It contains the following properties: ProjectsURLBase ProjectsURLBase is the context path of Help projects on the Tomcat server. ProjectsDirBase ProjectsDIrBase is the top-level directory of the Help projects. This directory is same as the installation directory. Note: Do not edit the following properties manually: Database Type, DSN, dsnuser, dsnpwd, ProjectURLBase, and ProjectDirBase. In addition to the above properties, the RoboHelp Server.properties file has many other properties. See "Enable user authentication" on page 14. Set up RoboHelp Server After you install RoboHelp Server, the system or network administrator completes the configuration using Configuration Manager. Complete the following steps in the authoring tool (see the RoboHelp HTML Help): 1 Open a project. 2 Create or edit a single source layout (specify FlashHelp® Pro or WebHelp Pro as the output type).