Pervasive PSQL v9 OLE DB Provider - May 2006

This document contains the following topics:

About the OLE DB Provider
Features
System Requirements
Getting Started

Installation
Components List
Using the PVideoDB Sample Database

Known Issues
Useful Links
Disclaimer

About the OLE DB Provider

This release of the OLE DB provider for Pervasive PSQL contains the following resources:

OLE DB binary files
OLE DB documentation

Features

See OLE DB Provider Guide for complete information on the features of the OLE DB provider. This manual is included in PDF format and can also be viewed in the Pervasive Library at: http://www.pervasive.com/library/index.asp?_pub=ole_910.

System Requirements

Existing install of Pervasive PSQL v9 Engine
MDAC 2.5 (2.7 or higher preferred). See http://msdn.microsoft.com/data/mdac to obtain MDAC.

Getting Started

Installation

here is no separate install for the OLE DB interface. The OLE DB runtime binaries listed under the Components List are installed by the PSQL engine installation. PSQL v9 SP2 OLE DB SDK is available for download at: http://www.pervasive.com/developerzone/access_methods/oledbado.asp.

Components List

Component
POLEDB.DLL
POLEDBER.DLL
POLEDBSY.DLL

Using the PVideoDB Sample Database

The SDK includes the data files and dictionary files (DDFs) for a sample database named PVideoDB. The sample database simulates the management of a video store. The data files and DDFs are located in <directory>\samples\PvideoDB, where <directory> is the directory where you installed the OLE DB provider.

In addition, the OLE DB provider includes code samples for use with the PVideoDB database. To use the code samples, you must first create the PVideoDB database.

Note: If you are using a Linux server and windows client, use the following procedure to compile the sample files:

Browse to PSQL-SDK-OLEDB-9.50.066.000-Win32.exe usually present in the build repository.
Unzip this file to the convienent folder of your choice (For example: \OLEDBSDK).
When the file is unzipped, the following subfolders are created:Samples\Vbasic
In the file ..\samples\Vbasic\PVideoVB.vbp is ADOcommon.bas under modules. Open the file.
Edit the following line:
Public Const ConnStr = "Provider=PervasiveOLEDB;Data Source=PVideo"
to
ConnStr = "Provider=PervasiveOLEDB;Data Source=;Location=<server name where >"
Compile the code to build the executable.

To create the PVideoDB database

Start Pervasive PSQL Control Center from the Pervasive group in the Start menu.
In Pervasive PSQL Explorer, expand the Engines node.
Right-click on the desired server where the database engine is running.
Click New --> Database.
Type "PVideoDB" for Database Name.
Specify <directory>\samples\PVideoDB for Location.
Click Finish.
Exit Pervasive PSQL Control Center.

Known Issues

The following are known issues with this and previous releases:

Defect	Description
31168	The OLE DB driver cannot open files in exclusive mode Currently, we have no support for exclusive access from OLEDB. It is not a supported property.
53423	OLE DB does not support GUID/UNIQUEIDENTIFIER

Useful Links

Discuss all your Pervasive development issues at DevTalk at http://www.pervasive.com/devtalk.

See some creative applications and code snippets and share your own at Pervasive ComponentZone at http://www.pervasive.com/componentzone.

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.