Technical Papers

Choose the technical paper below that corresponds to your interest.

Pervasive.SQL 2000i Embedding Guide
This Guide to Embedding is a tool to help you decide the best way to embed Pervasive.SQL into your application, and then to provide you the resources to complete the technical parts of your chosen method.

ODBC performance issues with Pervasive.SQL 2000 SP3 (PDF)
Pervasive.SQL 2000i (Pervasive.SQL 2000 SP3), provides a much richer SQL syntax and includes many new features such as Dynamic Cursors. Designed to allow your application to provide more robust relational capabilities, Dynamic Cursors can greatly enhance your application, but they can also affect performance depending on what you want to do. This paper explores the Service Pack 3, Dynamic Cursors, and configuration options.

Pervasive ActiveX Controls (PDF)
Designed as a thin wrapper for the Btrieve API for use in Microsoft Visual Basic, the Pervasive ActiveX Controls are a high-performance, easy-to-use set of tools for rapidly developing database applications in any programming language or development environment that supports ActiveX (OCX) controls. This paper reviews use of the ActiveX controls and provides sample code for implementation.

Accessing Your Pervasive.SQL Databases Online with J2EE (PDF)
Looking at moving your Pervasive.SQL 2000i database to the web? Wondering of J2EE is the way to go? This White paper explores the interfacing your Pervasive.SQL 2000i database with Java 2 Enterprise Edition. It includes reviews of architectures, Java Servlets, and advanced web application features.

Best Practices with PervasiveOLEDB (PDF)
The Advanced Guide for using ADO and Pervasive.SQL 2000i.

Making Your Windows NT/NetWare Application Work With Pervasive.SQL 2000 for Unix (PDF)
This document provides a high-level overview of Pervasive.SQL 2000 on the Unix (Solaris, Linux) platform.

MKDE System-Level Transactions (PDF)
What happens in the Pervasive.SQL 2000 engine when an application inserts, updates, or deletes a record? The application may be using the Btrieve API, ODBC, Java, or any other interface, but ultimately the insert, update, or delete request gets to the MicroKernel Database Engine (MKDE), which is responsible for getting that change into the physical Btrieve file on the disk. This paper explores MKDE internals, the parameters that control it and optimization techniques.

• Download the Pervasive.SQL 2000i Brochure
• Download a 30-day trial of Pervasive SQL 2000i
• Read Web Energy's success profile with Pervasive SQL 2000i success.pdf (70kb)

Buy Pervasive SQL 2000i online!