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