Hello,
As Alan and Chuck point out, the SCHEMA file produced by Adager and/or FO from
QUERYNM provides sufficient detail as to the tables (datasets) and fields
(items) of an Image database. I have provide these, along with an
explanations such as 'X6' means a 'char' of 6 characters, 'search item' would
be an 'index' and so on. In addition, I provided narratives of what each
'table is used for, FO listings of representative records, and screen shots of
how our users access the data. Should be sufficient - and they seemed to
indicate an understanding.
Now - with a few days before they visit our office, they have again requested
the diagram approach. Visio has an 'external database feature, and I've set up
the ODBC connection on this PC but I'm still getting an error when I try to
use it. It's probably some simple thing but so far, I can't seem to get past
this connectivity issue.
I took a look at the DBVisualizer - this is exactly the format I want, but I'm
not sure if they support the Image thru ODBC - Lars, would you know?
I'll be in the office later today (Saturday) trying to get this done, and I
have email access at home as well.
Thanks.
Connie Sellitto
[log in to unmask]
---------- Original Message -----------
From: Alan Yeo <[log in to unmask]>
To: [log in to unmask]
Sent: Fri, 11 Mar 2011 23:23:37 +0000
Subject: Re: [HP3000-L] ODBC connection used in Visio2010
> In message <[log in to unmask]>, Connie
> Sellitto <[log in to unmask]> writes
> >Hello,
> >Trying to set up the ODBC connection to 'reverse engineer' a database
> >diagram using Visio2010 and Minisoft's ODBC driver. As far as I can
> >tell, I've got the ODBC connection configured exactly as on our SQL
> >server where it works fine. But I'm getting an error "error 4 Error
> >creating server process!" in Visio.
> >
> >Has anyone used Visio to 'diagram' an HP3000 Image database?
> >
>
> Connie
>
> I think you are beating yourself up with no need.
>
> If you have Adager/Flexibase/DBGeneral or already have a good schema
> file for the databases, just generate the schema files and import
> them into word or excel and give them to whoever they are.
>
> If they can't put together the data structure from that, no amount
> of time you can spend with visio is going to impart any more information.
>
> A schema file isn't difficult to understand, and if they can't there
> isn't much you can do to help them.
>
> A few pointers on the schema file like this is a Primary Key this is
> a sorted key and indications that a specific numeric has (n) implied
> decimal places should be the most they should need plus a couple of
> pages from the Image manual that describe the data types. Image
> structures aren't complex.
>
> Alan
>
> --
> Alan Yeo
> [log in to unmask] Just because you're paranoid
> Phone +44 1684 291710 it doesn't mean someone isn't!.
> Fax +44 1684 291712
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
------- End of Original Message -------
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
