Pervasive PSQL v10.10 - ADO.NET Readme
General Release - March 2009

Contents


The document contains the following topics:

About Pervasive Data Provider for .NET

This is the latest release of the Pervasive PSQL Data Provider for .NET Framework 2.0, 3.0, 3.5, and 3.5 (SP1)

The Pervasive Data Provider for .NET runs as 100% managed code and requires the Microsoft .NET Framework 2.0, 3.0, 3.5, and 3.5 (SP1). However, you are required to have the Framework already installed prior to using the Pervasive ADO.NET provider.

System Requirements

What’s New in this Pervasive PSQL ADO.NET Data Provider Release?

The highlights of Release 3.2 are:

Getting Started

The runtime files for the ADO.NET access method are installed with the Pervasive PSQL engine by default.

The sample files and libraries needed for the membership provider and VS.NET integration are available via Web download in an archive file: http://www.pervasive.com/developerzone/access_methods/adonet.asp.

The membership provider should be installed on the computer where .NET application development will be performed, and also on the client computer(s) that will execute the application.

The membership provider is installed to the Global Assembly Cache (GAC) during the installation process.

ADO.NET contains new functionality for Pervasive PSQL v10.x. See What’s New in Pervasive PSQL for details.

Documentation

In the Pervasive PSQL SDK documentation, see Data Provider for .NET Guide and Pervasive PSQL Programmer's Guide.

Membership Provider for ASP.NET 2.0

The ASP.NET Login controls use the custom Pervasive Membership Provider to specify a separate database for storing user information.

Additional information about writing a custom membership provider is available at http://msdn2.microsoft.com/en-us/library/f1kyba5e.aspx.

See Libraries for the location of the membership provider.

The sample ASP.NET application included with the libraries and samples shows how to create users, change passwords, recover passwords, and validate users.

Installing the Sample Files and Membership Provider Libraries

After you download the archived file from www.pervasive.com/developerzone/access_methods/adonet.asp, un-archive it. Run the adonetsetup.exe file, which installs the ADO.NET sample files and membership provider libraries.

Libraries

The setup file installs the following libraries in the Program Files\Pervasive Software\PSQL\Bin\3.0 folder. Note that the “program files” location varies depending on the bit-architecture of the operating system. See “Where are the Pervasive PSQL files installed?” in Getting Started With Pervasive PSQL.

File
Description
PSQL.Membership.Provider.dll
Allows the ASP.NET Login controls to use a PSQL database.
PSQL.VisualStudio.DataTools.dll
Used by the VS.NET development environment for Server Explorer integration.

Samples

The following table summarizes the samples provided with ADO.NET. By default, the samples are installed to Pervasive Software\PSQL\ado.net\3.2\samples under All Users\Application Data. Note that the “application data” location varies depending on the bit-architecture of the operating system. See “Where are the Pervasive PSQL files installed?” in Getting Started With Pervasive PSQL.

Folder
Sample
Purpose of Sample
C#
CommandBuilder
Creating a command from an SQL statement
CreateDatabaseObjects
Creating database objects such as a table or stored procedure
DataAdapter
Using the data adapter to read or modify data
DataGridUpdate
Updating data in a grid control
DataReader
Using the data reader to get data
Escapes
Processing escape functions in statements
LimitingRows
Limiting the number of rows returned in a result set
LocalTransactions
Processing a transaction
LongDataTypes
Using long data types such as LONGVARCHAR
ScalarValue
Executing scalar functions to return a value
StoredProcedures
Using stored procedures
MembershipProvider
ASPX files for using the membership provider with the ASP.NET Login controls
Various login activities, changing password, and so forth
VisualBasic.NET
Same type of examples as listed for C#
Same as for C#

Membership Provider Requirements

Steps to use the Membership Provider

  1. Create the Pervasive PSQL database using V2 metadata. (See “To create a new database” in Pervasive PSQL User's Guide.)
  2. Create the table using the “Users Table Script” below.
  3. Modify the membership section settings in WEB.CONFIG. See “Example Modified WEB.CONFIG” below.

Login Controls within ASP.NET will now use the Pervasive Membership Provider.

Users Table Script
CREATE TABLE Users 
( 
  PKID UniqueIdentifier NOT NULL PRIMARY KEY, 
  Username Char (255) NOT NULL, 
  ApplicationName char (255) NOT NULL, 
  Email Char (128) NOT NULL, 
  Comment Char (255), 
  "Password" Char (128) NOT NULL, 
  PasswordQuestion Char (255), 
  PasswordAnswer Char (255), 
  IsApproved SmallInt, 
  LastActivityDate DateTime, 
  LastLoginDate DateTime, 
  LastPasswordChangedDate DateTime, 
  CreationDate DateTime, 
  IsOnLine SmallInt, 
  IsLockedOut SmallInt, 
  LastLockedOutDate DateTime, 
  FailedPasswordAttemptCount Integer, 
  FailedPasswordAttemptWindowStart DateTime, 
  FailedPasswordAnswerAttemptCount Integer, 
  FailedPasswordAnswerAttemptWindowStart DateTime 
) 
Example Modified WEB.CONFIG
<connectionStrings> 
<add name="PsqlServices" 
connectionString="ServerDSN=ASPNETPSQL;" /> </
connectionStrings> <system.web> 
<membership defaultProvider="PsqlMembershipProvider" 
userIsOnlineTimeWindow="120"> 
<providers> 
<clear /> 
<add  
name="PsqlMembershipProvider"  
type="PSQL.Membership.PsqlMembershipProvider"  
connectionStringName="PsqlServices" 
enablePasswordRetrieval="true" 
enablePasswordReset="true" 
requiresQuestionAndAnswer="true"  
writeExceptionsToEventLog="true"  
debug="false" 
passwordFormat="Clear"/> 
</providers> 
</membership> </system.web>

Data Provider

See the chapter “Using the ADO.NET Data Provider” in Data Provider for .NET Guide.

Known Issues

This release has no known issues.

Technical Support

You may obtain technical support from the following Web-based support options:

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.

Copyright ©2009 Pervasive Software Inc. All Rights Reserved.


Pervasive Software Inc.
http://www.pervasive.com
12365 Riata Trace Pkwy, Bldg B
Austin, TX 78727 USA
Voice: (512) 231-6000
Fax: (512) 231-6010
Online Pervasive Contacts

*** END OF README ***