HP 3000 Manuals

HP PC API User's Guide for ALLBASE/SQL and IMAGE/SQL

Connecting From Application Software 

Application software may have specific requirements for connection to PC
API. Those requirements are discussed here.

Connecting From Microsoft Access 

To use Microsoft Access to connect to ALLBASE/SQL, follow these steps:

   *   Run Microsoft Access (click on the icon).

   *   From the File menu, click on New Database and press Return.

   *   The New Database dialog box displays a default name.  You can
       change that name if desired.  Click on OK.


          Figure 2-1.  New Database Dialog Box 

   *   From the Microsoft Access File menu, click on Attach Table.

   *   At the Attach dialog box, move the cursor down and highlight <SQL
       Database>.  Click on OK.


          Figure 2-2.  Attach Dialog Box 

   *   At the SQL Data Sources dialog box, select the Data Source Name
       and click on OK. This will connect you to the PC API ODBC driver.


          Figure 2-3.  SQL Data Sources Dialog Box 

   *   At the HP MPE/iX Logon Information dialog box, fill in the server
       name, DBEnvironment name, and logon information.  Click on OK.


          Figure 2-4.  Logon Information Dialog Box 

   *   At the Attach Tables dialog box, highlight the table you want to
       access and click on the Attach button.  Each remote table must be
       attached.


          Figure 2-5.  Attach Table Dialog Box 

   *   Proceed to use Microsoft Access to manipulate tables using the
       commands described in the Microsoft Access User's Guide.

Connecting from Visual Basic 

To connect to ALLBASE/SQL using Visual Basic, do the following:

   *   Run Visual Basic (click on the icon).

   *   From the File menu, click on Open Project.

   *   Highlight the \vb\samples\vbodbc directory

   *   Highlight the visdata.bas file


NOTE  If you are using Microsoft Access or Visual Basic to update
      ALLBASE/SQL tables, you must define a unique index on the table.
      This requirement is imposed by Microsoft Access and Visual Basic,
      not the ODBC interface.

MPE/iX 5.0 Documentation