Pervasive PSQL v10.10 - ADO.NET Readme
General Release - June 2008

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.

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

System Requirements

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.10. 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.

Samples

The following table summarizes the samples provided with ADO.NET. By default, the samples are installed to Pervasive Software\PSQL\ado.net\3.0\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.

Membership Provider Requirements

Steps to use the Membership Provider

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 Data Provider in Visual Studio 2005” 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 ©2008 Pervasive Software Inc. All Rights Reserved.

*** END OF README ***