HP 3000 Manuals HP 3000 Manuals
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.
Click here to view figure.
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.
Click here to view figure.
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.
Click here to view figure.
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.
Click here to view figure.
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.
Click here to view figure.
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.