PFXodbc

The Powerflex ODBC Driver

PFXodbc works like a charm to allow access to data contained in PFXplus and compatible file formats from any ODBC-compliant front-end application.

PFXodbc can be used as a data source from applications like MS SQL Server, MS Access, MS Excel, MS Word, Borland Delphi, Crystal Reports, and many, many more.

PFXodbc Desktop for Windows Version 5.0

Adds support for files greater than 2 Gb
New on-line help
Supports all versions of PFXplus data files (and Dataflex too!)
Supports PFXplus - compatible Btrieve files
Works on Windows 2000/XP/Server 2003/Vista

Using PFXodbc

This example will demonstrate how to usePFXodbc as a data source in MS Visual Basic 6.0. The ODBC driver has been configured to use the sample data files which come standard withPFXplus. The configuration settings for the sample data files are:

Data Source Name = PFXodbc
Default User ID =   pfxuser
Data Base Name = SAMPLEDATA
Data Search Path =   C:\PFX440;C:\PFX440\SAMPLE

Start up Visual Basic
Add a Data Control to your Form
Add Labels and Text Boxes
Set Data Control Properties
Set the following Data Control Properties.
```
Caption = Members Data File
Connect =   ODBC;UID=pfxuser
Database Name = PFXodbc
DefaultType = 1 –   UseODBC
RecordSource = pfxuser.Member
   Or
RecordSource = select * from Member where 
sex = ‘M’ order by surname
```
When setting the RecordSource property, you can enter the name of a data file (in this case the MEMBER data file) or you can enter an SQL statement as the Record Source. The SQL statement above will return male member records only, in surname order.
Set the Text Box Properties
```
DataSource = Data1
DataField = given_names
```
When setting the DataField, a list of all of the fields in the RecordSource (the MEMBER file) of the Data Control will be displayed in the DataField drop down list. Select given_names from the drop down list.

Repeat this step for each Text Box.
Set the Label Properties
```
Caption = First Name:
```
Repeat this step for each Label.
Run the Form

Running the Form will generate the results below, which displayPFXplus data from the MEMBER file accessed viaPFXodbc.

PFXodbc example

The ODBC driver conforms to Microsoft ODBC version 3.0 and can be used with ODBC version 3.0 or later.

Buying PFXodbc

Check our price list forPFXodbc and contact Powerflex Corporation or your local dealer for further details, or complete and send the order form to order your copy now! (Discounts apply if more than 1 copy of a single-site licence are purchased simultaneously. Please contact us for discount details.)

Please FAX the completed form to +61 3 9548-9003, or POST to Powerflex Corporation Pty Ltd, P.O. Box 624, Mount Waverley, VIC 3149, Australia, or E-mail: see the sales email address on the Contact Us page of this website.