UPLOADING THE PC APIs.
 
The IMAGE/SQL installation tape has about 180 files that are required to
install, manage and run
IMAGE/SQL.  One of these files is HPPCAPI.PUB.SYS and is about 6,500 sectors.
 This file contains
both API used by various programs to connect to ALLBASE/SQL and then
IMAGE/SQL.  These two
APIs are ODBC (Open Data Base Connectivity, a Microsoft standard) and GUPTA,
another popular API.
 
Step 1, create a directory on your PC to hold the files.
C:\>MD HPPCAPI
 
 
Step 2, download the file HPPCAPI.PUB.SYS and unpack it.
 
Run Reflection and download the file HPPCAPI.PUB.SYS to HPPCAPI.EXE in the
HPPCAPI directory.
The download will take some time, on my LAN, it took over 4 minutes.
 
 
Step 3, Unpack the file and create two new directories.
 
C:\HPPCAPI>HPPCAPI
A question will be asked about the fact that the file will be unpacked in
your current directory.  Answer Y
to get the job done.
 
Two new files will be created:  HPODBC.EXE and GUPTA.EXE.
You can now purge the HPPCAPI.EXE file
C:\HPPCAPI>DEL HPPCAPI.EXE
 
Create two new sub-directories:
C:\HPPCAPI>MD ODBC
C:\HPPCAPI>MD GUPTA
 
Step 4, go to the ODBC subdirectory and unpack HPODBC:
 
C:\HPPCAPI> CD ODBC
C:\HPPCAPI\ODBC> ..\HPODBC
 
About 20 files will be unpacked.  Now go to the GUPTA directory and unpack
HPGUPTA.
 
C:\HPPCAPI\ODBC> CD ..GUPTA
C:\HPPCAPI\GUPTA>..\HPGUPTA
 
About 20 files will be unpacked.  Now to finish this step, go back to the
HPPCAPI directory and delete the
three files as they are big, and no longer needed.
 
C:\HPPCAPI\GUPTA> CD..
C:\HPPCAPI> DEL *.*
 
 
Step 5, installing the APIs for use.
 
Start Windows and go to the FILE RUN... command. For the GUPTA API you enter
\HPPCAPI\GUPTA\SETUP.  A new Windows group will be created and the API will
be available.
 
For the ODBC API, the command is \HPPCAPI\ODBC\SETUP.  Unlike the GUPTA API,
this will take
you into some screens in Windows where you will need to declare some data
sources.
 
The first screen to come on will be the Microsoft ODBC setup, just click on
CONTINUE.
 
The screen INSTALL DRIVER will be displayed next, with HP ALLBASE/SQL as an
entry.  Click on HP
ALLBASE/SQL and then click ok.
 
A file will be copied, then the ADD DATA SOURCE screen will be displayed with
a few examples.  Click
on ADD and the enter a unique data source name, such as SALES and a fitting
description.  Click on OK
and the final screen will be displayed and the ODBC API is installed.
 
 
Step 6, for ODBC only.  You need to edit the ODBC.INI file in the Windows
directory to tell ODBC
where to find your DBE, and how to logon.
 
[ODBC Data Sources]
MMDBE=HP ALLBASE/SQL
BATCH=HP ALLBASE/SQL
musicdbe=HP ALLBASE/SQL
Parts=HP ALLBASE/SQL
Excel=Q+E ExcelFile
sales=HP ALLBASE/SQL
 
[sales]
Driver=C:\WINDOWS\SYSTEM\allbase.dll
Description=Sales database
LastUser=#mpeix/ALPHA:salesdbe.sql.hicomp#odbcses,mgr.hicomp
DefaultIsolation=RU
 
Step 7, for ODBC only.  Simply verify that the file \WINDOWS\ODBCINST.INI
looks like this:
 
[ODBC Drivers]
Access Data (*.mdb)=Installed
FoxPro Files (*.dbf)=Installed
dBase Files (*.dbf)=Installed
Paradox Files (*.db )=Installed
SQL Server=Installed
Access 2.0 for MS Office (*.mdb)=Installed
HP ALLBASE/SQL=Installed
 
 
[HP ALLBASE/SQL]
Driver=C:\WINDOWS\SYSTEM\allbase.dll
Setup=C:\WINDOWS\SYSTEM\allbassp.dll
 
 
 
 
Step 8, for ODBC only, you need to upload the command file ODBCVIEW to the
HP3000 and execute
on your DBE.
 
So start Reflection and transfer in ASCII mode, the file
\WINDOWS\SYSTEM\ODBCVIEW.HP to a
group and account that can access your DBE.  This file is not very big, and
will tranfer quickly.  Next,
start ISQL.PUB.SYS on the HP3000:
 
:ISQL
 
isql=> CONNECT TO  SALESDBE ;
isql=> START ODBCVIEW;
isql=> EXIT;
 
 
 
Step 9, for ODBC only. You must declare the data source to  ODBC in Windows.
 
Start Windows and click on the MAIN icon.
In the MAIN program group, click on the CONTROL PANEL icon.
Click on the ODBC icon. You will see a list of existing data sources in the
DATA SOURCES window.
Click the ADD button.  A list of Drivers will appear in the ADD DATA SOURCES
window.
Click on HP ALLBASE/SQL line. The HP ALLBASE/SQL ODBC SETUP window is
displayed.
 
Enter the name of your data source exactly as you entered it in the ODBC.INI
file above.  The description
will be displayed and you are now ready to access this data source.
 
 
 
 
 
 
 
Step 10, for GUPTA only.  You will need to edit the file SQL.INI in the
ALLBASE directory.
 
[ALLBASE]
mpedbname=server1,ALPHA:salesdbe
mpeuser=sysadm,mgr.hicomp,sql
;hpuxdbname=server1,hpuxsysid:/path/dbe
;hpuxuser=sysadm,userid:passwd
[dbrouter]
heap=40000
[dbwindow]
cache=50
dbdir=C:\SQLBASE
[sqlrtrw]
retry=1
[winclient.dll]
comdll=sqlawin
[winclient.nbiow]
RetryTimeout=10
[dbdfault]
DEFAULTDATABASE=DEMO
DEFAULTUSER=SYSADM
DEFAULTPASSWORD=SYSADM
[winservr]
dbname=demo
 
@(#)Client-Server ALLBASE SQL.INI. Version A.F0.24
 
 
 
 
 
UPLOADING INFORMATION ACCESS.
 
Each IMAGE/SQL site has a license for one client copy of Information Access.
 This is a C/S tool from
HP that accesses IMAGE/SQL database through the ALLBASE/SQL DBE.  To use
Information Access,
you need to install the client copy on your PC.  This is what you need to do.
 
 
STEP 1
 
Verify that the file INFOACCS.PUB.SYS exits.  If it does not, look for it on
the IMAGE/SQL tape or in
the PPC.SYS group. The file is 16240 sectors long,  close to 4.2 megabytes.
 Start Reflection and down
load the file to a separate directory, adding the EXE extension:
 
C:\>MD INFOACCS
C:\>CD INFOACCS
 
Download the file here. and add the EXE extension.
 
 
 
 
STEP 2 Unpacking Information Access.
 
C:\INFOACCS>infoaccs
 
The standard question will be asked.
 
A new directory will be created, C:\INFOACCS\NWACCESS which will contain a
number of files and a
number of sub-directory.  When this is completed, start Windows and do a
File.. Run and use the
following command:  \INFOACCS\NWACCESS\INSTALL.
 
The program will ask you if you wish to install Information Access for
NewWave and/or Windows.  I only
installed the one for windows.  At the end of the installation, a new program
group will appear in program
manager.  Information Access is ready to use.
 
 
The database is ready for use either through Information Access or any ODBC
or Gupta compliant tool.
Information Access let s you use either API and also has its own facility to
connect to the HP3000.
 
Click on InfoAccess, then click on the Connection menu.
Click on Create connection.  A list of servers will be displayed.
You can either select ALLBASE/SQL MPE or  Microsoft ODBC.
 
Select a connection name, such as SALES.
 
If you selected ODBC, you will need to provide the data source name as above,
the description will
appear.
 
If you selected ALLBASE/SQL MPE, you will have to provide the name of the
environment, and logon
information.
 
Either way, once the connection is created, select this connection and off
you go. . .
 
 
IMAGE/SQL and Microsoft Access
 
 
 
 
 
 
 
 
 
Client/Server with IMAGE/SQL    December, 1994   denys p. beauchemin