Using Microsoft Visual Basic with Pervasive Data

Show this topic in Library frames

This chapter discusses how to use Microsoft Visual Basic to view and manipulate data in the sample database, which is installed with Pervasive.SQL. When you use Visual Basic to access Pervasive data, you can choose from several access methods, as follows:

Visual Basic's bound ActiveX Data Objects (ADO)

Third-party data controls, such as those offered by Classic Software

Direct ODBC API calls

Direct Btrieve API calls

These methods are listed roughly in order of development time and run-time performance, with ADO applications taking the least time to develop and direct Btrieve applications taking the most time. Conversely, direct Btrieve applications perform fastest at runtime; ADO applications perform slowest at runtime.

This chapter contains the following sections:

"Lesson 1: Setting Up Your Environment" on page 3-2

"Lesson 2: Using the ADO Data Control (ADODC)" on page 3-6

"Lesson 3: Writing Code with ActiveX Data Objects" on page 3-14

For information about using third-party controls, contact the vendor for that product. For information about using direct ODBC API calls, refer to SQL Language Reference. For information about using direct Btrieve API calls, refer to Pervasive.SQL API Programmer's Reference.

Note
The lessons in this chapter show screens from Visual Basic 6 only. Where necessary, differences between Visual Basic 5 and 6 are noted. Although Visual Basic 3 supports a bound text box data control, Visual Basic 3 is not discussed in this tutorial.