mime-version: 1.0 date: Fri, 25 Jun 2010 16:39:26 -0500 content-transfer-encoding: quoted-printable content-location: http://ww1.pervasive.com/developerzone/access_methods/readme_oledb.html x-mimeole: Produced By Microsoft MimeOLE V6.00.2900.5931 from: subject: Pervasive PSQL v9 OLE DB Provider content-type: text/html; charset="Windows-1252" Readme PSQL v9 OLE= DB Provider

Pervasive PSQL v9 OLE DB Provider - May 2006

This document contains the following topics:

About the OLE DB Provider

This release of the OLE DB provider for Pervasive PSQL contains the fol= lowing=20 resources:=20

Features

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

System Requirements

Getting Started

Installation

here=20 is no separate install for the OLE DB interface. The OLE DB runtime binari= es=20 listed under the Components List are installed by the PSQL engine installa= tion.=20 PSQL v9 SP2 OLE DB SDK is available for download at: http://www.pervasive.com/developerzone/access_methods/oledba= do.asp.=20

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 sampl= e=20 database named PVideoDB. The sample database simulates the management of a= video=20 store. The data files and DDFs are located in=20 <directory>\samples\PvideoDB, where <directory> = is the=20 directory where you installed the OLE DB provider.

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

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

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

To create the PVideoDB database

  1. Start Pervasive PSQL Control Center from the Pervasive group in the= =20 Start menu.=20
  2. In Pervasive PSQL Explorer, expand the Engines node.=20
  3. Right-click on the desired server where the database engine is runni= ng.=20
  4. Click New --> Database.=20
  5. Type "PVideoDB" for Database Name.=20
  6. Specify <directory>\samples\PVideoDB for Location.=20
  7. Click Finish.=20
  8. Exit Pervasive PSQL Control Center.

Known Issues

The following are known issues with this and previous releases:

Useful Links

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

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

Disclaimer

PERVASIVE SOFTWARE INC. LICENSES THE SOFTWARE AND DOCUME= NTATION=20 PRODUCT TO YOU OR YOUR COMPANY SOLELY ON AN "AS IS" BASIS AND SOLELY IN=20 ACCORDANCE WITH THE TERMS AND CONDITIONS OF THE ACCOMPANYING LICENSE AGREE= MENT.=20 PERVASIVE SOFTWARE INC. MAKES NO OTHER WARRANTIES WHATSOEVER, EITHER EXPRE= SS OR=20 IMPLIED, REGARDING THE SOFTWARE OR THE CONTENT OF THE DOCUMENTATION; PERVA= SIVE=20 SOFTWARE INC. HEREBY EXPRESSLY STATES AND YOU OR YOUR COMPANY ACKNOWLEDGES= THAT=20 PERVASIVE SOFTWARE INC. DOES NOT MAKE ANY WARRANTIES, INCLUDING, FOR EXAMP= LE,=20 WITH RESPECT TO MERCHANTABILITY, TITLE, OR FITNESS FOR ANY PARTICULAR PURP= OSE OR=20 ARISING FROM COURSE OF DEALING OR USAGE OF TRADE, AMONG OTHERS.

Copyright (c) 1999-2006 Pervasive Software Inc. All Rig= hts=20 Reserved.

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