Connecting to an ASA database on Windows CE  Defining the ASA data source

Chapter 14: Using database interfaces

About ASA data sources

ASA includes two database servers—a personal database server, dbeng9.exe, that can be used on a single desktop, and a network database server, dbsrv9.exe, that supports communications across a network. The network database server is always used on Windows CE systems.

Basic software components for ASA

Figure 14-1 show the basic software components required to connect to an Adaptive Server Anywhere data source in PocketBuilder.

Figure 14-1: Components of an Adaptive Server Anywhere connection

The PocketBuilder ODB interface (pkodb20.dll) calls ODBC functions to submit SQL statements, to catalog requests, and to retrieve results from a data source.

The Microsoft ODBC driver manager (odbc32.dll) installs, loads, and unloads drivers for an application.

NoteNo ODBC driver manager on Windows CE There is no ODBC driver manager on Windows CE. For more information, see “Connecting to an ASA database on Windows CE”.

The ASA ODBC driver (dbodbc9.dll) processes ODBC function calls, submits SQL requests to a particular data source, and returns results to an application. The driver also translates an application’s request so that it conforms to the SQL syntax supported by the ASA database.

The ASA data source stores and manages data for an application.

Preparing to use the ASA data source

Before you define and connect to an ASA data source in PocketBuilder, follow these steps to prepare the data source.

StepsTo prepare an ASA data source:

  1. Make sure the database file for the ASA data source already exists.

    You can create a new database using ASA outside of PocketBuilder, or by launching the Create ASA Database utility from the Utilities folder in the Database Profiles dialog box. For more information, see the chapter on managing databases in the User’s Guide.

    You can also convert an enterprise database for use with PocketBuilder. For more information, see “Preparing remote databases”.

  2. Make sure you have the log file associated with the ASA database so that you can fully recover the database if it becomes corrupted.

    If the log file for the ASA database does not exist, the ASA database engine creates it. However, if you are copying or moving a database from another computer or directory, you should copy or move the log file with it.




Copyright © 2004. Sybase Inc. All rights reserved. Defining the ASA data source

View this book as PDF