Pervasive.SQL V8 SDK (v8.5)
General Release - March 2004
READSDK.HTM

Contents

1. Welcome
2. General Information
3. Links to Other Information
4. Known Issues
5. Documentation
6. Technical Support
7. Disclaimer


1. Welcome

Thanks for using the Pervasive.SQL V8 SDK. This SDK contains all the necessary software components and tools to develop Pervasive.SQL database applications.

This version of the SDK contains the following updates:

Support for Features in Pervasive.SQL V8 (v8.5)

The v8.5 SDK release contains the following new features to support the Pervasive.SQL V8 (v8.5) release.

Simplified Components Installs

The previous SDK was broken up into separate component installs, and a main install that would include each of the component installs.

The Pervasive.SQL V8 (v8.5) SDK is distributed with three separate installs:

The components previously installed by the ActiveX and Java Class Library modules are now merged into the main SDK install. The components previously installed by the OLEDB, JDBC, and DTO modules are no longer included with the SDK install. Instead, these components are installed by the Pervasive.SQL engine and client installations.

Updated Windows Samples

This release adds or updates the following samples on the Windows platform:
Feature Samples AvailableWhere to Find
Btrieve Login API C++ C:\pvsw\sdk\samples\intf\c
Web-based Pvideo store Samples for Windows ASP, ASP.NET, Perl, PHP, Java Server Pages (JSP) C:\pvsw\sdk\samples\web

New Linux SDK

A Linux version of the SDK is available for the first time. This SDK provides samples, documentation, and header files to create Btrieve, ODBC, DTI, and web-based applications on the Linux platform.

Linux Samples Provided with New SDK

This release adds or updates the following samples on the Linux platform:
Feature Samples AvailableWhere to Find
Btrieve Login API C++ /usr/local/psql/sdk/samples/btrieve
Distributed Tuning Interface C++ /usr/local/psql/sdk/samples/dti
Web-based Pvideo store Samples for Linux Perl, PHP, JSP /usr/local/psql/sdk/samples/web

Installing the Linux SDK

To install the SDK on Linux:

  1. Log on as root user.
    su
    
  2. Change directories to PVSW_ROOT.
    cd /usr/local/psql 
    
  3. Copy the SDK tar to this location.
    cp /<path_to_tar>/sdk.tar . 
    
  4. Unpack the SDK tar file.
    tar -xvf sdk.tar
    
  5. Run the install script.
    sh ./sdk/etc/sdkinstall.sh
    

Uninstalling the Linux SDK

To uninstall the Pervasive.SQL SDK:

  1. Log in as root user.
    su 
    
  2. Change directories to PVSW_ROOT.
    cd /usr/local/psql 
    
  3. Run the uninstall script.
    sh ./sdk/etc/sdkuninstall.sh 
    
  4. Remove the extra files that the script cannot remove. You will still have the /sdk/etc folder left with the two scripts and the tar file. If you want to preserve the ability to reinstall, do not perform this step.
    rm -Rf /usr/local/psql/sdk 
    


Return to top of page.


2. General Information

The SDK supports both the Server and Workgroup engines of Pervasive.SQL V8.

Server engines are available for:

Workgroup engines runs on:

Client applications may run on:

See Getting Started with Pervasive.SQL (Server or Workgroup editions) for more information on supported platforms.

Visit the Developer Center

Pervasive is committed to bringing you the tools, information, and resources to take advantage of Pervasive.SQL.

Come join us at our Developer Center, the web resource for all your development needs: information, updates, samples, tools, and more:

http://www.pervasive.com/developerzone

While you’re there, join Pervasive DevWire and TechWire, two email newsletters that are your best source of news for Pervasive web and database developers! Up to date information delivered right to your desktop! Sign up on the Subscription Center at http://www.pervasive.com/support/subscription.asp

Summary of SDK v8.x Features

The 8.x SDKs include the following features:

FeatureDescriptionDescribed in manuals
ADO/OLE DB support

The Pervasive OLE DB provider marks the next level of connectivity for developers using Microsoft Visual Studio and other tools. The Pervasive OLE DB Provider is level 2.5-compliant provider for use with OLE DB consumers, including ActiveX Data Objects (ADO), Microsoft’s latest high-level data model for Visual Basic, Visual C/C++, and Active Server Pages.

The Visual Basic version of the PVideo sample application uses the OLE DB driver.

Programmer's Guide, Visual Programmer's Reference

see also OLE DB Readme, Links to Other Information, What's New in Pervasive.SQL V8

Pervasive Direct Access Components for Delphi and C++ Builder

Pervasive Direct Access Components for Delphi and C++ Builder allows Borland Delphi and C++ Builder developers to seamlessly access a Pervasive data source from within either Inprise/Borland development environment. By implementing the TDataSet classes, the data aware components within these environments will be able to take full advantage of a Pervasive data source with higher performance than using the built in access to ODBC via the Borland Database Engine (BDE).

The components support direct Btrieve access via the TPvTable class and SQL access via the TPvQuery class. A PVideo example is provided in the SDK for Delphi 5-7 and C++ Builder 5-6.

Visual Programmer's Reference contains installation instructions

see also PDAC Readme,Links to Other Information

JDBC driver and Java Class Library Enhancements

Interfaces in the Pervasive Java Class Library provide support for Binary Large Objects or BLOBs. BLOB support allows Java developers the ability to represent large binary files such as GIF, JPEG, and WAV files as Java objects that can then be stored in and retrieved from the database. A Java object serialization example is included.

The Pervasive.SQL JDBC driver gives developers the benefit of a standard data interface, remote data access, and support across all platforms supporting the JVM. You can use the server, workgroup, or workstation engine in conjunction with this driver.

Programmer's Guide, API Programmer's Reference

see also JDBC Readme

Tuning Interfaces

The Distributed Tuning Objects (DTO) and Distributed Tuning Interface (DTI) gives developers an unprecedented level of access to information about Pervasive.SQL database engines. The major categories of interfaces supported are:

  • Connection - establish and discard connections to remote database servers
  • Configuration - settings for the database engines and license management
  • Monitoring and Diagnostics - engine statistics and resource usage
  • Catalog - manage database catalog information (database names, table names, table properties, etc.)

DTI is a procedural interface and can be used with C or Delphi.

DTO is a COM-based set of objects and can be used with any IDE that supports COM, including Visual Basic, Visual C++, Delphi, and C++ Builder.

API Programmer's Reference (DTI)

Visual Programmer's Reference (DTO)

see also DTI Readme, DTO Readme

New DTI functions: PvAddLicense(), PvDeleteLicense(), PvGetMkdeCommStatEx(), PvGetMkdeUsageEx(), PvGetMkdeVersion()
New DTO objects: DtoLicenseMgr, DtoMkdeVersion, DtoEngineInformation

Samples

This release includes the following samples:

  • Pvideo for Visual C 6.0 - uses ADO
  • Pvideo for Delphi
  • DTO for Visual Basic
  • DTI for Visual C 6.0 and Delphi 5
see the \SAMPLES folder under your SDK installation folder

See also Pervasive ComponentZone for additional sample code.


Return to top of page.


3. Links to Other Information

You may find the following web sites of interest in learning about the technologies present in this SDK:

Pervasive Developer Center - Developer news, updates, samples http://www.pervasive.com/developerzone
Pervasive Component Zone - Developer community samples http://www.pervasive.com/componentzone
JDBC API Page - Sun Microsystems http://java.sun.com/products/jdbc
Microsoft Universal Data Access Site - for introduction to Microsoft solutions such as ADO and OLE DB http://www.microsoft.com/data
Borland Programming Tools - Information and resources for Delphi and C++ Builder development http://www.borland.com
Pervasive DevTalk - Developer community technical discussion and support forum http://www.pervasive.com/devtalk

Return to top of page.


4. Known Issues

The Pervasive.SQL SDK issues are documented in separate readmes for the Windows-based components. Depending on which options you selected, you may not have some of these readmes on your system.

  1. ActiveX Readme
  2. OLE DB
  3. Distributed Tuning Interface Readme
  4. Distributed Tuning Objects Readme
  5. Pervasive Direct Access Components (only if PDAC installed)
  6. Java Class Library
  7. JDBC

Note on Linux Samples and the GCC compiler

The Pervasive.SQL C samples for Linux require a GCC version of at least 3.0.4. Otherwise, the samples may produce segmentation faults when run. To download an updated GCC compiler, see http://gcc.gnu.org/releases.html

Uninstalling v8.1 SDK After v8.5 SDK

Your Start menu items related to the Pervasive.SQL SDK and your SDK documentation can be removed in error if you perform the following sequence of steps:

  1. Install Pervasive.SQL v8.5 engine.
  2. Install Pervasive.SQL SDK v8.1
  3. Install Pervasive.SQL SDK v8.5
  4. Uninstall the v8.1 version of the SDK.

To work around this issue, run the Repair feature of the SDK install to add the shortcuts and documentation.

Return to top of page.


5. Documentation

A README document (this document) in HTML format is included in the SDK. There is also a duplicate version in plain text format (readsdk.txt).

In addition to the installed manuals, you can view the v8.5 SDK documentation online and download documentation updates at the Pervasive Library, which you can reach at http://www.pervasive.com/library/index.asp?_pub=PSDK_850

Windows documentation

Online documents in HTML Help format are provided in the SDK. The master help file PVSWDOCS.CHM that was installed with your Pervasive.SQL Server or Workgroup engine, or your Pervasive.SQL client, includes the complete set of online documents for both your Pervasive.SQL engine and the SDK, including an integrated table of contents, index, and glossary. You can load PVSWDOCS.CHM via the Windows Start menu:

Start | Programs | Pervasive.SQL V8 |Documentation | Pervasive.SQL V8

Linux documentation

The documentation is shipped in HTML format and can be browsed at /usr/local/psql/sdk/doc/html/index.html.

The Pervasive Library also contains the full set of documentation at http://www.pervasive.com/library/index.asp?_pub=PSDK_850

Documentation Notes

Return to top of page.


6. Technical Support

Return to top of page.


7. Disclaimer

PERVASIVE SOFTWARE INC. LICENSES THE SOFTWARE AND DOCUMENTATION PRODUCT TO YOU OR YOUR COMPANY SOLELY ON AN "AS IS" BASIS AND SOLELY IN ACCORDANCE WITH THE TERMS AND CONDITIONS OF THE ACCOMPANYING LICENSE AGREEMENT. PERVASIVE SOFTWARE INC. MAKES NO OTHER WARRANTIES WHATSOEVER, EITHER EXPRESS OR IMPLIED, REGARDING THE SOFTWARE OR THE CONTENT OF THE DOCUMENTATION; PERVASIVE SOFTWARE INC. HEREBY EXPRESSLY STATES AND YOU OR YOUR COMPANY ACKNOWLEDGES THAT PERVASIVE SOFTWARE INC. DOES NOT MAKE ANY WARRANTIES, INCLUDING, FOR EXAMPLE, WITH RESPECT TO MERCHANTABILITY, TITLE, OR FITNESS FOR ANY PARTICULAR PURPOSE OR ARISING FROM COURSE OF DEALING OR USAGE OF TRADE, AMONG OTHERS.

© Copyright 2004 Pervasive Software Inc. All Rights Reserved.


** End of READSDK.HTM **