About the Server Engine

---

This section provides some basic information about the Pervasive.SQL Server engine. For a detailed discussion of Pervasive.SQL architecture, please refer to Pervasive Products and Services.

If you would like more information about what comes in your product and what gets installed, please see Chapter 2, Preparing to Install Pervasive.SQL.

Purpose

You have purchased the Pervasive.SQL Server engine. This database engine is designed to support up to many hundreds of concurrent network users when installed on the appropriate hardware. It is capable of supporting web, corporate, departmental, and other client/server or web-based applications where reliability and performance are critical.

Where to Install

The Server engine must be installed on the same computer where the database files are located. The client portion of the software must be installed on every computer that is expected to access the database. In the case of web applications, the client must be installed on the same computer as the web server. Multiple web server platforms require a client on each platform.

Additional User Licenses

If you receive Status Code 161 or other status codes indicating you have exceeded your licensed user count, you may wish to buy additional user licenses. You can purchase additional licenses in blocks of 10, 20, 50, 100, or more. You may purchase user count upgrades from your application reseller or directly from Pervasive.

Features

All Pervasive database engines offer the same powerful feature set and full-functioned support for programming interfaces. All engine editions are plug-and-play compatible, requiring no application changes to switch from one engine to another. Data files are binary-compatible across all supported platforms.

The chart below shows the major differences between the two different editions of the product.

 
Table 1-1    Comparison of Server and Workgroup Features

Feature	Server	Workgroup
Supports Btrieve, ODBC, OLE-DB, and ActiveX interfaces	ü	ü
Full-featured relational support (online backup, security, referential integrity, management tools, and so on)	ü	ü
Binary compatible data files across all platforms and engine editions	ü	ü
Easy plug-and-play upgrading, no application changes required	ü	ü
Includes complete online documentation	ü	ü
Can access data on a file server where no database engine is installed		ü
Supports remote ODBC client connections	ü	ü
Requires a Workgroup engine on all computers expected to access remote data	N/A	ü
Engine runs on Windows	ü	ü
Engine runs on NetWare	ü
Engine runs on Linux	ü
Multi-user for small groups	ü	ü
Scales to hundreds of users	ü
Extranet license available	ü