HP3000-L Archives

October 2000, Week 2

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Steve Patterson <[log in to unmask]>
Reply To:
Steve Patterson <[log in to unmask]>
Date:
Thu, 12 Oct 2000 12:29:44 -0300
Content-Type:
text/plain
Parts/Attachments:
text/plain (51 lines)
Mike, I think you should already have MB Foster's "free" ODBC driver,
depending on your version of MPE/iX.  See if you have HPREADME.ODBCSE.SYS,
the first few lines tell you how to install the host listener.

I was given the task of populating an Image DB from data supplied in an
Excel spreadsheet.  Using MS Access and ODBCLink/SE, I was able to link the
Excel S/S's, link the Image DB datasets, then selectively copy and paste
from the S/S to the Image datasets.  Once I figured out how to do it, I
automated the whole thing via macros.  Not bad for my first stab at using
Access.  Performance is not all that great, but this is a once-per-quarter
type of procedure that doesn't need instantaneous response.

FWIW,

==============================================
Steve Patterson                                 [log in to unmask]
Halifax Port Authority                        www.portofhalifax.ca
Halifax, Nova Scotia
Canada


----- Original Message -----
From: "Mike Whiteley" <[log in to unmask]>
To: <[log in to unmask]>
Sent: Thursday, October 12, 2000 11:48 AM
Subject: Re: Quote of the week


> All,
>
> IHHO Oracle has the same potential to be open as Cobol or c or Allbase. If
I
> choose to use areas of those products that depart from the standard, then
it
> is I who has made my application non-open.
>
> I recently constructed a small application that uses ODBC, and discovered
it
> works on MSAccess,Oracle and SQLServer (once I had created my tables of
> course).  That's what I call open, and reinforces Richard's assertion that
> "The SQL standard is the only thing meaningfully open."
>
> I'd like to see whether it works on Image/SQL also, so if Birket's
listening
> I'd be happy to receive my free copy of his ODBC driver:)   - I'd be
> delighted to post results, if Birket's up to it:)
>
> Mike Whiteley
> SMA, Houston TX
>

ATOM RSS1 RSS2