I agree with Alan.  If someone can't map data from an Image Schema, there isn't 
much more help you could give them.  I've done it with an FO in Query.  I feel 
for you Connie.  Why they need you to provide such a presentation, as has been 
seen on this thread this week, is beyond me.
 
 
Chuck Trites
>[log in to unmask]
>Trites Consulting, Inc.
>P.O. Box 5473
>Weirs Beach, NH 03246
>Phone: (603) 219-1500




________________________________
From: Alan Yeo <[log in to unmask]>
To: [log in to unmask]
Sent: Fri, March 11, 2011 6:23:37 PM
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 *




* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *