Plug Alert!
[log in to unmask]
Charles Finley, Open-Ended Systems Corp
310-957-2200

----------
> From: F. Alfredo Rego <[log in to unmask]>
> To: [log in to unmask]
> Subject: the HP3000 as a "client"?
> Date: Friday, November 21, 1997 5:34 PM
>
> Hi, all:
>
> I received this message.  Does anyone have a suggestion?
>
> Please feel feel to contact Patrick directly (I answered him with
> "Excellent question.  I don't know of an answer, but I'll ask several of
my
> friends").
>
> If you answer him directly, please also share your insights with the
list.
>
> Notice his signature: "MPE - To the Millenium and Beyond!!"
>
> Alfredo
>
>
>
____________________________________________________________________________

>
>
> Date: Fri, 21 Nov 1997 14:20:27 -0700
> From: [log in to unmask] (Patrick Santucci)
> Subject: HP3000 to HP9000 DB Connectivity
>
> HP3000 to HP9000 DB Connectivity
> Hello,
>
> I am looking for a database connectivity tool, but it's kind of an
> unusual request. Let me give you some background.
>
> We are migrating an Allbase/SQL database on one of our HP3000 (MPE/iX
> v5.0) machines to an Informix database (v7.23UC5) on one of our HP9000
> (HP-UX v10.20) machines. This is our tape library database which is used
> only by our computer operations department. Currently, system operators
> access the database by running a program from each 3000 system console,
> which has a DSLINE open to the HP3000 system where the database resides.
> Operations has requested that we *not* change their user interface; they
> would like to continue to type the same commands at the system consoles
> and have the system handle the database calls in the background. (Yes,
> training is a real issue here.)
>
> So what I'm looking for is some way to have the HP3000s access the
> Informix database on the HP9000 across our network (ethernet, TCP/IP) in
> a client-server fashion (here's the unusual part), where the HP3000 is
> the *client* requesting and updating information in the HP9000 *server*
> Informix database.  For example, does anyone know of an ODBC product
> where the HP3000 can act as the *client*?

There is a "reasonably simple" way to do this.  What I would do is use
the LeeTech Software CSF middleware solution.
        - It is inexpensive
        - It is fast (in operation)
        - It will allow the desired transparency.  (The user interface does not
          have to change).  You can build a simple API which, when used
          by the operator, they will not be able to tell that the database
          is on another computer!  This is done by having a stub program
          for each command on the HP 3000 and implementing the
          real API on the INFORMIX database.  The stub communicates
          with the real API through a simple sockets-based mechanism provided
          by the LeeTech solution.
        - Moreover, it doesn't really care which computer is the client or which
is
          the server.  We have implemented applications in which a PC is the
         server and the HP 3000 or HP 9000 is the client and vice versa.

Finally, although an ODBC solution would work, it is probably over kill in
terms
of the complexity it would bring to the solution.

We are a VAR for LeeTech.  Please call if you want to discuss the matter
further.
1-800-876-5975 x713 (Charles Finley)

>
> I look forward to hearing from you. Thanks in advance for any help you
> can give me.
>
> Patrick Santucci
> --
> "MPE - To the Millenium and Beyond!!"  - Buzz Wytukay
> =+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=
> Patrick Santucci, MIS12
> Technical Services Systems Programmer
> Kirke-Van Orsdel, Inc.                              Voice: 515-365-6582
> 1776 West Lakes Parkway                               Fax: 515-365-6444
> West Des Moines, IA 50398                  e-mail: [log in to unmask]
> =+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=