Connie

I have never tried using Visio to document an image database before, but 
thought I'd take a quick look to see how easy difficult it was.

Questions

1) I assume that on your HP3000 you have an IMAGE/SQL DBE generated that 
contains all the databases you want to document? If you haven't stop now 
and do as Denys suggests except I think there may be a better way by 
cutting and pasting from an FO Sets into Visio.

2) If you have a DBE set up, I assume that you already have some simple 
Microsoft Query's set up on your PC that access the databases via ODBC. 
If you haven't, then probably stop now and do it manually.

3) If you have got a MS Query set up try it in Excel first just to see 
that you have connectivity, if you haven’t well....

4) I found in vision that going to the database drivers via "options" 
under "database" it didn't seem to want to let me define/add an ODBC 
driver that I have that explicitly works with Image/Allbase. So as a 
guess when doing the reverse engineer I selected "Generic ODBC" it 
worked. You then need to select a MS QUERY that you have already defined 
that accesses that data source. (see 2 above if you haven’t then 
probably too much work at this stage, but maybe not if you know what 
your doing)

5) Magic it reversed engineered all the tables from a database that I 
had a query datasource defined for.


Now the bad news what you get are a whole load of visio boxes drawn for 
you with a list of all the items in each table/dataset. It certainly 
hadn't managed to reverse engineer the index paths.

So as far as I can see the magic reverse engineer function in visio is 
going to give them what you have already given them, but with a box 
drawn around each table, upon which you are going to have to add the 
index paths anyway.

Sorry but I'd say even if you get it working it ain't going to be the 
answer.

Alan






In message <001201cbe0c1$6d65d010$48317030$@net>, Denys Beauchemin 
<[log in to unmask]> writes
>You're spending an enormous amount of time trying to make tools work.  If
>this was something that would be ongoing, I can see spending the time for
>that, but for a one off thing?
>
>I would sit down with the schemas and some paper and simply draw the two
>level diagrams with a pencil, showing the links between master and details.
>Then I would simply scan the papers into a PDF file and call it good.
>
>Denys
>
>-----Original Message-----
>From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On Behalf
>Of Connie Sellitto
>Sent: Saturday, March 12, 2011 7:51 AM
>To: [log in to unmask]
>Subject: Re: [HP3000-L] ODBC connection used in Visio2010
>
>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]
>
>* To join/leave the list, search archives, change list settings, *
>* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

-- 
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 *