Common Questions After Installing Pervasive.SQL

This section contains information that you should read after running the installation program. If you are having problems with your installation, go to Chapter 12, Installation Troubleshooting, or get help online from our Knowledge Base website at http://support.pervasive.com/eSupport.

The Workgroup engine must be installed on every computer that is expected to share data within your workgroup. Because every computer must have the Workgroup engine installed, there is no need to install the client software separately as there is for the Server engine.

How to Handle Data Source Names (DSNs)

The following table describes the procedures for upgrading your DSNs after you have installed the Pervasive.SQL upgrade.

Table 5-2 How to Proceed After Installing Workgroup
If your situation is like this . . .	. . . then you should do this next:
You have existing Pervasive.SQL 7 DSNs already defined.	You must delete and re-create all existing Pervasive.SQL 7 DSNs before you can access existing databases. Follow the instructions provided in Pervasive.SQL User's Guide Chapter 2, sections Deleting DSNs and Setting Up Database Access on Windows.
You have existing Pervasive.SQL 2000 DSNs already defined.	You should be able to access your databases by connecting to the existing DSNs. Follow the instructions provided in Pervasive.SQL User's Guide, Chapter 2, section Accessing Data via ODBC From Other Applications.
You do not have any Pervasive.SQL DSNs defined	You should be able to connect to the sample DEMODATA database now. Refer to Pervasive.SQL User's Guide for general information on working with Pervasive.SQL. Refer to Pervasive.SQL Advanced Operations Guide for detailed information on working with databases and database engines.

How Do I Convert My Files From Previous Pervasive Products?

Converting your data files to 9.x format is not required, but you must convert them if you wish to take advantage of new features offered by the Pervasive.SQL 9 SP1 (9.1) engine.

Users of previous Btrieve versions: Use the Rebuild utility to convert your existing pre-6.0 or 6.x files to 7.x, 8.x, or 9.x format. For more information, refer to the Pervasive.SQL Advanced Operations Guide.

How Do I Read the Online Documentation?

Pervasive.SQL 9 SP1 (9.1) documentation for Win32 platforms is in Javahelp format. To read the documentation, select Start4Programs4Pervasive.SQL 9 SP1 (9.1)4Documentation4 Pervasive.SQL 9 SP1 (9.1) from the Windows Start menu.

You can also view the documentation in the form of Adobe Acrobat (PDF) files. These PDF files and an installation program for an Acrobat reader is available on the Pervasive.SQL 9 SP1 (9.1) (Server Edition) CD-ROM.

There is also a README file on the distribution media that has the latest changes and additions to Pervasive.SQL 9 SP1 (9.1).

What User License Was Installed with the Product?

The Pervasive.SQL 9 SP1 (9.1) installation program automatically installs a five user permanent license when you install a Workgroup engine product.

There is no configuration necessary for the license. After installation, you can use the License Administrator utility to view your installed licenses. See the Pervasive.SQL User's Guide for more information on the License Administrator utility.

What Files Were Installed as Part of Pervasive.SQL 9 SP1 (9.1)?

Once installed, Pervasive.SQL 9 SP1 (9.1) files reside in the following default directory structure.


\WINNT\SYSTEM32 (on WinNT/Win2000/WinXP systems) \WINDOWS\SYSTEM32 (on Win98 systems)			Microsoft system files Pervasive glue dlls
\Program Files\Common Files\Pervasive Software Shared
	\PSA		Pervasive System Analyzer
	\DOC		Online documentation
	\PVSWCORE		Pervasive Services
\PVSW
	\BIN		Pervasive.SQL engines, requesters, and utilities
		\PLUGINS		Pervasive Control Center and Javahelp documentation
	\DEMODATA		Contains sample database
		\PLUGINS		Pervasive Control Center and Javahelp documentation
	\SAMPLES		Contains the sample database SAMPLE.BTR and UPPER.ALT, a sample Alternate Collating Sequence
	\SCHEMAS		Example of COBOL Schema
	\SYSTEM		Pervasive System database