mime-version: 1.0 date: Fri, 25 Jun 2010 16:20:25 -0500 content-transfer-encoding: quoted-printable content-location: http://ww1.pervasive.com/developerzone/access_methods/readme_activex.html x-mimeole: Produced By Microsoft MimeOLE V6.00.2900.5931 from: subject: Pervasive PSQL ActiveX Controls content-type: text/html; charset="Windows-1252" ActiveX Controls R= eadme v9

Pervasive PSQL v9 ActiveX Controls - May 2006

This document contains the following topics:

About the ActiveX Controls

Pervasive's ActiveX interface is a set of nine custom controls that ena= ble=20 development environments that support ActiveX to easily access Btrieve dat= a. The=20 interface includes a data source control and eight bound data controls.

The Pervasive PSQL data source control provides the connection point be= tween=20 your application and a Btrieve data file. In addition to acting as a data = source=20 for other data-aware controls, the data control also exposes properties,=20 methods, and events you can use to access data from code in your=20 application-opening, closing, and creating files; and retrieving, updating= and=20 deleting records.

The Pervasive PSQL bound controls, which must be attached to the data s= ource=20 control, include data-aware text box, list box, combo box, check box and o= ption=20 button controls. The list and combo box controls operate either as field-b= ound=20 controls or as multi-column record list controls.

Command button and horizontal and vertical scroll bar controls provide= =20 indexed record navigation.

In Microsoft Visual Basic, the Pervasive PSQL data source control can a= lso=20 act as a record source for data-aware Visual Basic controls, and for third= -party=20 data-aware ActiveX controls.

System Requirements

Getting Started

Installer

Install the ActiveX controls by running setup.exe. You can= =20 choose Typical, Complete, or Custom installations. The Typical installatio= n=20 omits the MSI redistributable files found in the Complete installation. Fo= r more=20 information about ActiveX, see the ActiveX section of the Pervasive Develo= per=20 Center at http://www.pervasive.com/developerzone/access_methods/active= x.asp=20

Components List

The installation will then proceed to install the following ActiveX=20 components to the \pvsw\bin directory for a Typical or Comple= te=20 Install:

Component

Description

ACBTR732.OCX

ActiveX Data Access Control

ACCTR732.OCX

ActiveX Bound Controls

PBTRVD32.DLL

Meta data handling DLL

PEDTCONV.DLL

Data conversion DLL

Files relating to Redistributing ActiveX in other installations are ins= talled=20 with a Complete install or Custom install if selected. If installed, they = are=20 located in \sdk\Redist\ActiveX\msi

Known Issues in this Release

The following are known issues with this release.

Issue Number Description
52378 After connecting to and disconnecting from a remote = host,=20 VAccess properties still displays table name and selected fields of = the=20 previously connected database.
52379 DdfPath, Location, and Join buttons cannot be operat= ed=20 from the keyboard.
53342 The ActiveX controls do not update LONGVARCHAR type= =20 fields. They read existing data, but if you change the field and do = an=20 update/insert, status returns success, but the field has not changed= . I=20 This is not a new issue with 9.5 (all 9.x versions have it) but it w= ould=20 be great if it could be resolved.
53378 ActiveX does not support the entire range of BigInt= =20 values. This is also an issue in previous Pervasive PSQL versions.
53784 ActiveX does not support the GUID/UNIQUEIDENTIFIER d= ata=20 type.
53785 ActiveX does not support the DateTime data=20 type.

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=20 AGREEMENT.
PERVASIVE SOFTWARE INC. MAKES NO OTHER WARRANTIES WHATSOEVER= ,=20 EITHER EXPRESS OR IMPLIED, REGARDING THE SOFTWARE OR THE CONTENT OF THE=20 DOCUMENTATION; PERVASIVE SOFTWARE INC. HEREBY EXPRESSLY STATES AND YOU OR = YOUR=20 COMPANY ACKNOWLEDGES THAT PERVASIVE SOFTWARE INC. DOES NOT MAKE ANY WARRAN= TIES,=20 INCLUDING, FOR EXAMPLE, WITH RESPECT TO MERCHANTABILITY, TITLE, OR FITNESS= FOR=20 ANY PARTICULAR PURPOSE OR ARISING FROM COURSE OF DEALING OR USAGE OF TRADE= ,=20 AMONG OTHERS.

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