How to setup an ODBC database on the hp3000 (959 Views)
Reply
Advisor
kevin h_2
Posts: 49
Registered: ‎04-16-2007
Message 1 of 2 (959 Views)
Accepted Solution

How to setup an ODBC database on the hp3000

I have a program that I would like to update a dataset on the 3000. What steps are required for this? We are running MPEix 6.5. I have been away from the "database side of things" for a while.
Honored Contributor
Kwan Fong, Emile
Posts: 1,162
Registered: ‎07-10-2000
Message 2 of 2 (959 Views)

Re: How to setup an ODBC database on the hp3000

Hello Kevin,

First, you'll first need to setup an IMAGE/SQL DBE; then you can use ODBC to access it.

In the ITRC Technical Knowledge base, there is a good document for that. The document ID is KBRC00006588 (Setting up an IMAGE/SQL DBE and installing ODBCLINK on MPE/iX 6.0 or Higher).

Here's an integral copy of the document:

PROBLEM

How to set up an IMAGE/SQL DBE and access it from a PC.


RESOLUTION

1. Set up ODBCLINK server
=========================

Do a :SHOWJOB and confirm that your job limit is set so that at least
one more job can log on. Change the limit if necessary.

The ODBCLink job needs to run in the CQ. Do a :JOBPRI to check if the
MAXIMUM JOB PRI = CS. If not, type:

:JOBPRI CS

Then

:STREAM ODBCJOB.ODBCSE.SYS

If necessary, do a JOBPRI DS or ES.

Use :SHOWJOB to confirm the job ODBCLNSE,MANAGER.SYS is running.

You may want to put the jobpri & stream steps into a UDC/command file, your backup jobs and your SYSSTART file.


2. Create an IMAGE/SQL DBE
==========================

This section assumes that this is a new installation of an IMAGE/SQL database connection. You may already have performed some or all of these steps.

The purpose of these steps is to create an Allbase DBE and attach a TurboImage database to it. Your ODBC applications will 'talk' to the Allbase DBE, which will translate the SQL commands into Image Intrinsics.

Log on as the creator of your TurboImage database and perform the following steps, where 'imagedb' is the name of your Turboimage database, and 'newdbe' is the name of the Allbase DBE you wish to create:

:IMAGESQL
>> set turbodb imagedb
>> set sqldbe newdbe
DBE does not exist, do you want to create one? [Y/N} : Y
Creating DBE now ...
>> attach
>> update user user.account to mode = 1 << this is your current logon
<< not required if the DBE is
<< is to be READ ONLY
>> exit

:sqlutil
>> altdbe
DBEnvironment Name: newdbe
Maintenance Word:
AutoStart mode (on/off) (opt):
User Mode (single/multi) (opt):
DDL Enabled (y/n) (opt):
No. of Runtime Control Block Pages (opt):
No. of Data Buffer Pages (opt):
Data Buffer Pages Memory Resident (y/n) (opt):
No. of Log Buffer Pages (opt):
Max. Transactions (opt): 50
Maximum Timeout (opt): 300
Default Timeout (opt): 300
Authorize Once per Session (on/off) (opt):
Alter DBEnvironment Startup Parameters (y/n)? y

DBEnvironment startup parameters altered.

>> exit


3. Set up client - TCP/IP
==========================

Your network software must be able to connect to the HP3000. Test this by 'pinging' your HP3000 server using it's IP address.

C:\> ping 12.345.678.900

You may need to exit windows to run PING. If PING tells you it cannot find the IP address, contact your site network administrator for advice.

If you do not know the IP address of your HP3000, use the MPE command 'NETCONTROL' as below to find it.

:NETCONTROL STATUS;NET=LAN1


4. Set up client - ODBCLINK/SE
===============================

Create a new directory called ODBCLINK. At the DOS prompt:

C:\> MKDIR ODBCLINK
C:\> CD ODBCLINK

Download the file ODBCCL32.ODBCSE.SYS from your HP3000 server into this directory as ODBCCL32.ZIP. The method for doing this depends on your networking software. The file must be transferred in binary format.

Use WINZIP to unzip ODBCCL32 and install the ODBCLINK client.

To set up your data sources, select Data Sources (ODBC) from your Control Panel. At the 'ODBC Data Source Administrator' window select Add. At the 'Create New Data Source' window choose ODBCLink/SE-32 Driver (or
ODBCLink/SE-32 ODBC3 for level 3 compliant ODBC) & click Finish. At the 'ODBCLink/SE Setup' window enter data as follows:

Data Source Name: The name you will be calling your database
Description: A description of your choice
DataBase Name: The fully qualified filename of the DBE on the server
Server Name: The IP address of your HP3000
Click on the MPE/iX radio button & Continue

Enter your logon details in the next screen & Continue.

In the 'Setup Options' screen, click OK
In the 'Select Translator' screen, click OK
Back at the 'Data Sources' screen, click Close, and then OK to exit
SETUP.

You should now be able to connect to your Image/SQL database.

King is the customer!
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.